Function returns the name of the US Federal holiday for a date. The result will end in "Observed" if the date is an observation day for a holiday that falls on a weekend. Non-holidays and invalid dates return blanks.
DATE_FIELD ← 20201225 1324 20210702 20210701 20210703 20210704 20211224
isholiday DATE_FIELD
.→---------------------.
↓Christmas Day |
| |
| |
| |
| |
|Independence Day |
|Christmas Day Observed|
'----------------------'