Hi,

With the date as 1/31/2009 and B1 holding 1, your formula would return
3/3/2009 whereas the EDATE function would return 2/28/2009. I wonder which
one is correct. In your formula, B1 is interpreted as 31 days and therefore
the answer is 3/3/2009.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Mike H" wrote in message
...
Hi,

Try

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


date in a1 and months to add in b1

Mike

"Gene" wrote:

Excel 2003: I have a "date" in a cell (eg: 6/16/09), and want to
calculate
the date which is 6 months from now?
The issue I'm having is that some months are 29, 30, 31 days.

The "date" call value may change and the "x" months period could also
change.

Hope this is clear.
THANKS!
Gene:)