# How to calculate next month/year from a specified date

**URL:** <https://community.glideapps.com/t/how-to-calculate-next-month-year-from-a-specified-date/31396>\
**Category:** Ask for Help\
**Created:** [September 5, 2021, 9:18am UTC](https://community.glideapps.com/t/how-to-calculate-next-month-year-from-a-specified-date/31396 "2021-09-05T09:18:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Superwoman](https://avatars.discourse-cdn.com/v4/letter/s/b4bc9f/32.png) [@Superwoman](https://community.glideapps.com/u/Superwoman)\
**Post date:** [September 5, 2021, 9:18am UTC](https://community.glideapps.com/t/how-to-calculate-next-month-year-from-a-specified-date/31396/1 "2021-09-05T09:18:40Z")

</div>

Hi everyone,

Specified Date: 14 March 2021

How do I calculate one month and one year from the specified date on Glide? i.e. I need a way to get 14 April 2021 and 14 March 2022.

Context: The dates are inputted by the users and I want to show them their next payment date.

Thank you!

---

<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:** [September 5, 2021, 10:25am UTC](https://community.glideapps.com/t/how-to-calculate-next-month-year-from-a-specified-date/31396/2 "2021-09-05T10:25:52Z")

</div>

For getting the date one year from a specified date, the following should help:

> [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15):
>
> Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb …
