🗓 Month, Day, and Year Math Functions

[Jeff_Hager]

@spencersRus

Find the last day of the following month

Try this: FLOOR(275 * MONTH(date) / 9) - (FLOOR((MONTH(date) + 9) / 12) * (1 + FLOOR((YEAR(date) - 4 * FLOOR(YEAR(date) / 4) + 2) / 3))) + DAY(date) - 30 Don’t ask how it works, because I don’t know. Found it here. https://www.epochconverter.com/daynumbers Also found some other formulas on other sites, but didn’t quite understand how to make it work in glide. I thought I would maybe need a seed date column with a Jan 1st to calculate from, but this way works without a seed date.