Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change 2006 calendar to 2007 and save dates in Excel
I want to convert a 2006 monthly calendar to 2007 and save the 2006
information by date on the new calendar. -- Brent |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change 2006 calendar to 2007 and save dates in Excel
It's going to depend on how your calendar is organized. In a properly
constructed calendar, you would simply change the Jan 1st date to 2007, and the rest of the year would be propagated with formulas. If that's not the case with your calendar, tell us how it's organized so we can help you update it. -- Regards, Fred "Brent P." wrote in message ... I want to convert a 2006 monthly calendar to 2007 and save the 2006 information by date on the new calendar. -- Brent |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change 2006 calendar to 2007 and save dates in Excel
It is based on a MS template and the dates seem to be fixed. I decided to
build my own based on formulas as you suggest. If there are shared versions of such calendars, especially if they are in the same worksheet please let me know and thank you for responding. -- Brent "Fred Smith" wrote: It's going to depend on how your calendar is organized. In a properly constructed calendar, you would simply change the Jan 1st date to 2007, and the rest of the year would be propagated with formulas. If that's not the case with your calendar, tell us how it's organized so we can help you update it. -- Regards, Fred "Brent P." wrote in message ... I want to convert a 2006 monthly calendar to 2007 and save the 2006 information by date on the new calendar. -- Brent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you change the File save locations in Excel 2007? | Excel Discussion (Misc queries) | |||
excel 2007 Beta-Charting | Charts and Charting in Excel | |||
Save Excel 2007 as Web Page - no interactivity? | Excel Discussion (Misc queries) | |||
Is there any File Auto Save Function for Excel and Word 2007 (Bet | Excel Worksheet Functions | |||
How can I save a file in Excel 2007 beta 2 as a .dbf extension? | Excel Discussion (Misc queries) |