I have a calendar view where we can add Holidays.
How can I check if [Date] is between one of our Holidays?
So in this example if [Date] = 03/20/2019 , then it’s TRUE.
But if [Date] = 03/15/2019 , then it’s FALSE.
It seems to me that this is a feature request for Calendar Functions. Ideally, one would want to express this as:
IF(INCLUDES(EVENT(“Holiday”), [Date]), TRUE, FALSE)
or alternatively,
IF(AND(EVENT_START(“Holiday”)> [Date], EVENT_END(“Holiday”)< [Date]), TRUE, FALSE)