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/