Adding months to a date

[Guest]

I need a formula to be able to add months to a date,
Example: If my date is 1/1/00 I want to add 18 (30,42,54, etc) months to it,
and calculate to 7/1/01 (7/1/02, 7/1/03,7/1/04, etc). I can get it to come
out using number of days but because of leap years some of the calculations
come out to 6/30 rather than 7/1. We use Office 03. Please help me!

 

[Roger Govier]

Hi

With start date in A1, and with 18 in B2, 30 in B3 etc.
Enter in A2
=DATE(YEAR($A$1),MONTH($A$1)+B2,1)
copy down
Format the cell with your preferred date format

 

[Guest]

Hi Miss Misty

Put this in any cell.

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

Put your date in A1 and the number of months to add in A2 and your done.

Miek

 

[Stan Brown]

Thu, 12 Apr 2007 04:40:02 -0700 from Mike

Put this in any cell.

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

Put your date in A1 and the number of months to add in A2 and your done.

What is the result of your formula when cell A1 contains 2007-01-31
and cell A2 contains 1?

I've been trying to think of a really general solution to the OP's
problem, and I can't think of one that's a reasonably short formula.