Find the last day of the following month

Ask for Help
25

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.

5 Likes