Date Calculation

[Guest]

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

 

[Dave R.]

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

 

[Niek Otten]

I'd prefer

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

--

But keep in mind what you want to happen if A1 is Feb 29 2004

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Paul Corrado]

Niek,

Depending on the application, using the formula Niek proposed could lead to
errors. If you check for example a start date of 8/29/04, adding six months
yields an answer of 3/2/05.

 

[Dave R.]

I get 3/1/05 with that formula, but I see your point.

 

[Guest]

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

.... of course it is ... right. You see, this is why I need to figure this
out.

Thank you very much.

Here is another question along the same line: If I have the date of
9/29/2004 in cell A1 and in cell A2 input 6 (months), what formula, if any,
could I use to add that 6 to 9/29/2004 and in receive a result of 3/29/2005?

Thank you again,

Suzanne

 

[Niek Otten]

Errors?
That depends. What do you suggest the correct value is?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Dave R.]

Just use

=EDATE(A1,A2)

A2 being 6 and A1 being the start date.

 

[Paul Corrado]

Niek,

As I indicated, the "correct" value depends on the application. A 6-month
lease, for example, entered into on August 29th, may expire on the last day
of February, not in March.

 

[Guest]

Thank you very much!

Just use

=EDATE(A1,A2)

A2 being 6 and A1 being the start date.

 

[Guest]

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