📆

Insert Holidays

Master Tag
Tips & Tricks
Created
Aug 31, 2020 03:06 PM
Usage
Contains
Month
Date
Day
Web Tags
Database
Design
Formula
Alternatives
Cover
A Calendar With Holidays
Name
Date
Weekday
Holiday?
Oct 31, 2020
Feb 14, 2020
Mar 17, 2020
Dec 31, 2020
Nov 26, 2020
May 9, 2021
Jun 20, 2021

Fluid Holidays

Find Thanksgiving (Last Thursday Of November | and(and(date(prop("Date")) >= 23, day(prop("Date")) == 4), month(prop("Date")) == 10)
Find Mothers Day (2nd Sunday Of May) | and(and(and(date(prop("Date")) >= 8, day(prop("Date")) == 0), date(prop("Date")) <= 14), month(prop("Date")) == 4)
Find Fathers Day (3rd Sunday Of June) | and(and(and(date(prop("Date")) >= 15, day(prop("Date")) == 0), date(prop("Date")) <= 21), month(prop("Date")) == 5)