Date calculation

[MIchel Khennafi]

Good morning,

I am working on a spreadsheet where I need to determine a future date based
on a date I entered

For Instance:
- In A1, I enter Feb 2, 2006
- In A2 I would like to automatically determine the end date Feb 1, 2007 (12
months after)
- In A3, I would like to automaticall determine another end date Feb 1, 2008
(24 months after)

Is there a way to do so without having to care about the number of days in
between 2 dates? I would like to avoid the very simple A2=A1+ 365days...
Especially when the number of days vary from one year to the other (leap
years)

Thanks

Michel

 

[Peo Sjoblom]

In A2

=DATE(YEAR(A1)+1,MONTH(A1),1)

copy down


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Zenaida]

Try

=SUM(A1+M12)

=SUM(A1+M24)

 

[Loomah]

Hi
You could also have a look at the EDATE function in the Analysis Toolpak if
you are dealing in months

Rgds, Loomah