Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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)) |
#3
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) | |||
How do i set up a calendar in excel? | Excel Discussion (Misc queries) | |||
Calendar and info for that date | Excel Discussion (Misc queries) | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |