Date Calculation
 

I wanted to say thanks! I was trying to figure out something similar,
although not quite but your formula below was able to get my juices flowing
and ultimately enabled me to find the result with the calculation I was
seeking!

Thanks so much for posting an answer to Suzanne's question! You made my life
and the life of my staff so much easier!

Michelle


"Dave R." wrote:

Hi, you can do this with

=EDATE(A1,6)

where A1 contains the date you are adding to. Be sure and format it as a
date.

or
=EDATE("9/29/04",6)

The result is actually 3/29/2005, not 5/29/2005 :)



"Suzerain" wrote in message
...
Hi. Does anyone know if there is a formula that I can use in Excel (XP
2003)
to calculate an end date if you are given the start (9/29/2004) and then
the
number of Months (6), that the formula cell would show (5/29/2005)?

Thanks in advance,

Suzanne