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 •


#1
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=?
Apple+Table=?

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.

Bryan


Report •

#2
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:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

Michael J


Report •

Related Solutions


Ask Question