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 |
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 |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com