Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a calendar in excel for the next 4 yeara
How can I create a calendar in excel for the next 4 years? Begin date is October 31, 2005 and end date is October 31, 2010. -- dyukon ------------------------------------------------------------------------ dyukon's Profile: http://www.excelforum.com/member.php...o&userid=30062 View this thread: http://www.excelforum.com/showthread...hreadid=497408 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a calendar in excel for the next 4 yeara
What form do you want the calendar to take? A very simple way is to
enter your start date in cell A1 and format it as mmmm dd, yyyy. Then in cell A2, enter the formula: =A1 + 1 and ensure that this is formatted in the same way. Then you can copy cell A2 into the range A3:A1461 to give you a four year span. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use Excel to create this text file? | Excel Worksheet Functions | |||
Create random number bingo cards with Excel | New Users to Excel | |||
Is there any way to create a drop down calendar into a cell in ex. | Excel Discussion (Misc queries) | |||
create price list from excel sheet | Excel Discussion (Misc queries) | |||
Outlook 2003 calendar events into Excel 2003? | Excel Discussion (Misc queries) |