🔔 Pre-Fill Important Dates
How does one pre-fill holidays inside a Notion calendar? This Notion formula will do the trick, however, your calendar must already have pre-filled date properties for it to work. The formula requires a date to read. As well, I want to show you how I return fluid holidays like Mother’s and Father’s day.
How To Pre-Fill Dates Into A Notion Database?
I compiled a list of 100+ dates from 2020 to 2021, and organized them into “monthly” cards. If you want to generate pre-filled dates yourself, I suggest also populating a date property so formulas like this can work smoothly. You can also purchase my pre-filled 2020/2021 calendar here.
The Holiday Formula
if(contains(format(prop("Date")), "Oct 31"), "🎃Halloween", if(contains(format(prop("Date")), "Feb 14"), "💘Valentine's Day!", if(contains(format(prop("Date")), "Mar 17"), "🍀St. Patrick's Day!", if(contains(format(prop("Date")), "Dec 31"), "⭐️New Year's Eve!", if(and(and(date(prop("Date")) >= 23, day(prop("Date")) == 4), month(prop("Date")) == 10), "🦃Thanksgiving", if(and(and(and(date(prop("Date")) >= 8, day(prop("Date")) == 0), date(prop("Date")) <= 14), month(prop("Date")) == 4), "💐Mother's Day", if(and(and(and(date(prop("Date")) >= 15, day(prop("Date")) == 0), date(prop("Date")) <= 21), month(prop("Date")) == 5), "🧢Father's Day", "")))))))
Formula Syntax For Fixed Holiday
if(contains(format(prop("Date")), "Oct 31"), "🎃Halloween"
If date contains “Oct 31”, return “Halloween”
Formula Syntax For Fluid Holiday
if(and(and(and(date(prop("Date")) >= 8, day(prop("Date")) == 0), date(prop("Date")) <= 14), month(prop("Date")) == 4), “💐Mother’s Day”
if date is held between the 8th and the 14th” the 14th, and the day of the week is a Sunday, and the month lands on May (0 being January), return “Mother’s Day”
