| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing worksheets to the next years dates
I have a full year by month worksheet where we enter daily tabulations. Is
there a way to change the dates from this years 2008 dates to continue on to the 2009 calender year. Otherwise I have to rebuilder 2009, cut and paste. -- R Heitzman |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing worksheets to the next years dates
Editreplace20082009
-- Don Guillett Microsoft MVP Excel SalesAid Software "R Heitzman" wrote in message ... I have a full year by month worksheet where we enter daily tabulations. Is there a way to change the dates from this years 2008 dates to continue on to the 2009 calender year. Otherwise I have to rebuilder 2009, cut and paste. -- R Heitzman |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing worksheets to the next years dates
Select last date. Right click.Drag over area for new dates and release
button.Select fill seriese 'Fill Month'. -- Clifford Roy "Don Guillett" wrote: Editreplace20082009 -- Don Guillett Microsoft MVP Excel SalesAid Software "R Heitzman" wrote in message ... I have a full year by month worksheet where we enter daily tabulations. Is there a way to change the dates from this years 2008 dates to continue on to the 2009 calender year. Otherwise I have to rebuilder 2009, cut and paste. -- R Heitzman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing dates and years with less keystrokes | Excel Worksheet Functions | |||
| changing dates in worksheets - help | Excel Discussion (Misc queries) | |||
| Dates = years old | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Changing dates entered in 2005 to previous years | Excel Worksheet Functions | |||
Linear Mode
