Fun with Dates

[Jeff_Hager]

Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way.

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 …