Return if dates is a holiday

[ltisdalecmg17]

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!

[Alexey_Gusev · Accepted solution]

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

[Sho]

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")