6 Unique Date Formulas For Building In Notion
As I curated a list of really cool date formulas for my blog, I stopped and thought about how much Notion can really do. Wondering what to do in Notion, how to approach the program, what pages to create and for what purpose? There are practically an infinite amount. In fact, I've spent the year creating 283 use-cases. And I'm only scratching the surface. With the addition of API (coming very soon!), the possibilities may truly be endless.
Date formulas I've used in bigger formulas that may be useful for your next build
What you need:
A date property named “Date”
A formula property to enter the code
Replace every instance of prop(“Date”) with now() to find all that applies below to the current day and time.
Highlight weekly progress:
slice("◻️◻️◻️◻️◻️◻️◻️", 0, day(prop("Date")) * 2) + "🔲" + slice("◼️◼️◼️◼️◼️◼️◼️", 1, 14 - day(prop("Date")) * 2)
Return week of the month:
ceil((date(prop("Date")) + day(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"))) / 7)
Return first day of the month:
dateSubtract(prop("Date"), date(prop("Date")) - 1, "days")
Return last day of the month:
dateSubtract(dateAdd(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"), 1, "months"), 1, "days")
How many days does the month have?:
date(dateSubtract(dateAdd(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"), 1, "months"), 1, "days"))
How many weeks does the month have?:
ceil((date(dateSubtract(dateAdd(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"), 1, "months"), 1, "days")) + day(dateSubtract(dateSubtract(dateAdd(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"), 1, "months"), 1, "days"), date(dateSubtract(dateAdd(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"), 1, "months"), 1, "days")) - 1, "days"))) / 7)
Content Published Last Week
Lecture And Class Notes Page Design Example In Notion - Red Gregory
What Does The Timestamp Function Do In Notion? - Red Gregory
Notion Template: Package Tracking And Online Shopping - Red Gregory