Help

Re: Return if dates is a holiday

Solved
Jump to Solution
511 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ltisdalecmg17
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

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

Alexey_Gusev_0-1689603443105.png

 

 

See Solution in Thread

2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

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

Alexey_Gusev_0-1689603443105.png

 

 
Sho
11 - Venus
11 - Venus

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