# Find the last day of the following month

**URL:** <https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557>\
**Category:** Ask for Help\
**Tags:** holdmybeer\
**Created:** [January 22, 2021, 6:02am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557 "2021-01-22T06:02:57Z")\
**Posts on this page:** 1\
**Showing post:** 35

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 3, 2022, 7:03am UTC](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/35 "2022-04-03T07:03:19Z")

</div>

> [@Milan\_Balogh](#):
>
> Is there an easy way to simply get +1 month? Next week is super simple, but I couldn’t figure this out.

heh… I posted a video about 10 minutes ago that shows how to do this 🙂

> [@If then else with DATE](https://community.glideapps.com/t/if-then-else-with-date/11328/18):
>
> @Food2Soil - here, I think this is a better approach… The math formulas used: To add an arbitrary number of months to a date: ((Now-DAY(Now)+15)+(Years/12\*365.25)) - DAY((Now-DAY(Now)+15)+(Years/12\*365.25)) + DAY(Now) To get midnight on the first day of the month from a given date: Date+1-Day(Date)-Hour(Date)/24-Minute(Date)/1440-Second(Date)/86400

---

_[View the full topic](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557)._
