Solved Excel forumula to add a month

Apple Mac Mini
January 28, 2007 at 15:28:45
Specs: OS X, Intel Core Duo 1.5 GB

There is a thread in this forum describing how to add 30 days to a month in Excel.  It is pretty easy.  (If the date is in A1, then "=A1+30" is 30 days later.)

What if, instead of adding 30 days, I want to add one
month?   I haven't been able to figure out how to do that.

See More: Excel forumula to add a month

Report •

January 29, 2007 at 03:26:15

Not sure of how you would apply such a formula but I also do not see how Excel could know which month you want to add.

Similarly the months, by name, are simply text so: 1/1/07+February=?

Excel, being a calculator, can only calculate numbers and not text.

Perhaps, if you could explain what you are wanting to do with this then perhaps an answer/solution could be presented.


Report •

January 29, 2007 at 11:03:00
✔ Best Answer

You will need to break the date down to its parts (day, month, year). Then add 1 to the month value and then recreate the date using the new parts. If the month is december (12) and you add 1 to it (13), Excel will handle it correctly and jump to the next year.

Assuming the cell A1 contains the data that you want to add 1 month to, the formula would be:


Michael J

Report •

Related Solutions

Ask Question