This is the latest version of my math formula to add months to a date. It will add the specified number of months, but if the calculated date does not contain the same day number, it will back date to the last day of the goal month. (ex. adding 1 month to Jan 31st will calculate to Feb 28th instead of Mar 3rd). I don’t know if this is exactly what you want. You would have to tell us what should happen if the month you calculate 2 months from now doesn’t contain the same day number as the start date.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How can I add 6 months to a date in a glide table? | 5 | 741 | June 22, 2023 | |
| Add 60 multiple rows with dates (today + monthly additions) | 7 | 92 | August 2, 2024 | |
| Date math - 3 months from a specific date | 9 | 960 | July 20, 2022 | |
| Trying to add number or subtract number of days from given date, cant | 11 | 122 | June 28, 2025 | |
| Is rolling up summary values based on dates - is there an easier way to do this? | 8 | 758 | October 28, 2022 |