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!

For getting the date one year from a specified date, the following should help: [image] Glide Editor screen goes blank when using Math Column Report a Bug 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 …

How to calculate next month/year from a specified date

Ask for Help

Darren_Murphy September 5, 2021, 10:25am 2

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

Topic		Replies	Views
Calculating next anniversary in Glide Ask for Help	2	671	August 25, 2021
Date math - 3 months from a specific date Ask for Help	9	1021	July 20, 2022
Find the last day of the following month Ask for Help holdmybeer	46	3522	January 17, 2023
Calculate the dates correctly Ask for Help	3	249	December 16, 2023
Is rolling up summary values based on dates - is there an easier way to do this? Ask for Help	7	809	October 27, 2022

How to calculate next month/year from a specified date

Related topics