How to calculate next month/year from a specified date

[Darren_Murphy]

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

Glide Editor screen goes blank when using Math Column

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) [image] ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb …