calendar
 

How can I go about creating a calendar within Excell in which due dates are
calculated automatically? (Date: 10/28/05 + 6 months =, Date + one year, Date
+ 5 years, etc.)

Please help.

Thank you in advance.
ds

calendar
 

The formula for the date plus six months is
=EOMONTH(A1,5)

For date plus one year
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

For date plus 5 years
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))

calendar
 

Thanks Dave

"Dave O" wrote:

The formula for the date plus six months is
=EOMONTH(A1,5)

For date plus one year
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

For date plus 5 years
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))