Adding Months based on Calendar Days not individual days
I am looking for a formula that adds months to a date and keeps the "x" day of the month. Meaning if I am adding 3 months from February 1st, 2021, it would return May 1st, 2021 vs. just adding 90 days to February 1st and returning May 2nd, 2021.
Best Answer
-
HERE is the original post. Take a look at that and see if it helps. If not, feel free to let me know, and I will try to work through a more personalized solution with you.
Answers
-
Are you wanting to add a set number of months, or would you want to be able to put a number in a column that represents the number of months to add so that it is variable?
-
I have a referenced column that I will be adding a certain number of months, that will then be added to a date. So yes the number of months will be a variable.
-
There are a few solutions out there already for this very thing. I believe the keyword was EDATE. I will take a look around and see what I can find.
-
HERE is the original post. Take a look at that and see if it helps. If not, feel free to let me know, and I will try to work through a more personalized solution with you.
-
Well done @Paul Newcome. Thanks for the help, this worked.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!