Skip to main content

Hi All,

I've been trying to use the below formula to exclude weekends, so rather than showing 7 days to show 5 days instead. it seem to make sense using 3 but I'm not sure why? when the formula is returned  and Date Reservation Time Stamp is blank it returns NaN Days Remaining is there a way to say IF {Date Reservation Time Stamp} is blank show as Blank on the output? 

formula I'm currently using 

DATETIME_DIFF((WORKDAY({Date Reservation Time Stamp},3)),TODAY(),'days') & " Days Remaining"

I don’t think your current formula does what you want even when there is a date.

Try something like this. (I’m typing on a phone so there might be some typos. You might also want to throw in a check to see if the date is in the future. )

 

IF(

  {Date Reservation Time Stamp},

  CONCATENATE(

    WORKDAY_DIFF(TODAY(),{Date Reservation Time Stamp}),

    " Days Remaining"

  )

)


I don’t think your current formula does what you want even when there is a date.

Try something like this. (I’m typing on a phone so there might be some typos. You might also want to throw in a check to see if the date is in the future. )

 

IF(

  {Date Reservation Time Stamp},

  CONCATENATE(

    WORKDAY_DIFF(TODAY(),{Date Reservation Time Stamp}),

    " Days Remaining"

  )

)


thank you, This formula makes the count down change from 5 days remaining to 1 day remaining. I want it to count down from {Date Reservation Time Stamp}) each day that passes the counter would drop a day until it reaches 0 


thank you, This formula makes the count down change from 5 days remaining to 1 day remaining. I want it to count down from {Date Reservation Time Stamp}) each day that passes the counter would drop a day until it reaches 0 



@lucyk wrote:

thank you, This formula makes the count down change from 5 days remaining to 1 day remaining. I want it to count down from {Date Reservation Time Stamp}) each day that passes the counter would drop a day until it reaches 0 


I'm having a hard time picturing this. Care to share a screen shot with example values?


Reply