Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing dates and years with less keystrokes
I am setting up a spreadsheet of investments. The first column (A, row 1)
has Monday 01/21/2008, the next row (column A, row 2) is Tuesday 01/22/08 and so forth through the end of the year (Wednesday 12/31/2008). It takes a long time to set all that up. I'm now wondering if the dates can be automatically changed - say from Monday 01/21 to Monday 01/19 and the years change from 2008 to 2009? Can that be done without my having to input all the dates again for next year? Thanks for any help you can give? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates = years old | Excel Discussion (Misc queries) | |||
Dates, Years and Seasons | Excel Worksheet Functions | |||
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 | |||
i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85. | Excel Worksheet Functions |