# 🗓 Month, Day, and Year Math Functions

**URL:** <https://community.glideapps.com/t/month-day-and-year-math-functions/16937>\
**Category:** Ask for Help\
**Created:** [October 9, 2020, 12:12am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937 "2020-10-09T00:12:01Z")\
**Posts on this page:** 1\
**Showing post:** 31

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 24, 2021, 4:11pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/31 "2021-02-24T16:11:02Z")

</div>

@spencersRus

> [@Find the last day of the following month](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/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](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.

---

_[View the full topic](https://community.glideapps.com/t/month-day-and-year-math-functions/16937)._
