Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm using Excel 2007 but I need this to work also on Excel 2003.
I want to set up a spreadsheet where I can automatically populate a set of cells with incremental dates in the format MMM-YY. When I use the MM-DD-YY format, I can do the following: Cell 1: Enter starting date Cell 2: = [Cell 1] + 1 With this, Cell 2 will increment the date from Cell 1. I can propagate this way through the spreadsheet. But, if I configure the cells for the date format of MMM-YY, it wont increment. Can anyone tell me if I can use a simple formula to increment dates in the format MMM-YY? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeating/incrementing dates 35039 times | Excel Discussion (Misc queries) | |||
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT | New Users to Excel | |||
Format text 'dates' to real dates | Excel Worksheet Functions | |||
Format dates | Excel Discussion (Misc queries) | |||
the dates on cell format make different dates. | New Users to Excel |