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!

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

--
Regards

Roger Govier


"miss misty" wrote in message
...
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!

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

"miss misty" wrote:

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!

Thu, 12 Apr 2007 04:40:02 -0700 from Mike
:
"miss misty" wrote:

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.

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/