Adding Months based on Calendar Days not individual days

Ross Novotny

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.

Paul Newcome

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.

Paul Newcome

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?

Ross Novotny

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.

Paul Newcome

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.

Paul Newcome

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.

Ross Novotny

Well done @Paul Newcome. Thanks for the help, this worked.

Paul Newcome

Happy to help. 👍️