close
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: www.excelforum.com/member.php...oamp;userid=30062
View this thread: www.excelforum.com/showthread...hreadid=497408What 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
全站熱搜
留言列表
