Holiday

[Jessi_Ortega]

I have a flow that I've been working on. I now need it to check if any of my dates matches a holiday date that I have in my Holiday reference Sheet. SoI want it to check the reference sheet and if it matches a date. I have a column that is titled CLOSE TODAY: IIF( DateTimeFormat([Delivery Date], '%A') IN ('Sunday','Saturday'), 'Weekend', IIF(DateTimeToday()=[Delivery Date],'True','False')) with this formula it tells me if it falls on the weekend and if the date is today which gives a result of False and True. Now I want it to check if the delivery date matches any of the dates in my HolidayReferenceSheet and if it does, I want the CLOSE TODAY to output 'Holiday'.

[CoG · Accepted solution]

Here is a sample that should do what you're looking for: