Skip to main content

I'm trying to return a value if the date matches any of a string of dates. I'm trying to make sure dates don't land on company holidays. Thanks!

Hi,
You can try WORKDAY_DIFF({Date},{Date},"list of dates")=0
Weekend will be also included, but I guess it doesn't contradict your goal

 

 

Using Workday_diff is a good idea!
If you don't need to add any particular holidays, you can use this formula as well.

 

IF(WEEKDAY({Date},"Monday")>4,"holiday")

 

 

Reply


Terms & Conditions