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

In A2

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

copy down


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"MIchel Khennafi" wrote in message
...
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

Try

=SUM(A1+M12)

=SUM(A1+M24)


--
Zenaida


------------------------------------------------------------------------
Zenaida's Profile: http://www.excelforum.com/member.php...o&userid=33802
View this thread: http://www.excelforum.com/showthread...hreadid=536882

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

Rgds, Loomah

"MIchel Khennafi" wrote in message
...
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