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.

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

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

Ask Your Question

Weekly Poll

Where do you plan to shop for the Holidays?

Discuss in The Lounge

Poll History