Solved

Return if dates is a holiday

+2

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!

Best answer by Alexey_Gusev

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

+25

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

+21

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

Sign up