All Tips

Notion Formula 2.0: Last Day of the Month

The last day of the month is a common software issue and different tools/languages require different implementation.

But usually, the algorithm is the same: First day of next mont - 1 day

Last Day of the Month Notion Formula:

For Notion users, Kavisha shared a pretty nice implementation:

lets(
 /* Gets the first date of the month */
 firstOfTheMonth, dateSubtract(today(), date(today()) - 1, "days"),
 
 oneMonthAdded, dateAdd(firstOfTheMonth, 1 , "month"),
 
 /* Gets the last date of the month */
 lastDateOfThisMonth, dateSubtract(oneMonthAdded, 1 , "day"),
 
 style("» Last day of the month: ", "gray") + style(lastDateOfThisMonth.format(), "b", "default")
)