| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto fill dates
I have a time sheet with a 'date' column for entry from a1 - a7. Once the
first date in a1 is entered (mm-dd-yy) is there a way to have the remaining cells auto fill the sequence of dates? -- Thanks! -Jennifer |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto fill dates
Just add 1 to the previous date. So, in cell A2, enter: =A1+1
Or, if you want cells A2-A7 to remain blank until a date is entered in A1, then use this formula: =IF(ISBLANK(A1),"",A1+1) HTH, Elkar "Jennifer" wrote: I have a time sheet with a 'date' column for entry from a1 - a7. Once the first date in a1 is entered (mm-dd-yy) is there a way to have the remaining cells auto fill the sequence of dates? -- Thanks! -Jennifer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill for data from another worksheet | Excel Discussion (Misc queries) | |||
| Auto fill dates | Excel Worksheet Functions | |||
| Auto Fill with some references locked | Excel Discussion (Misc queries) | |||
| auto posting dates | New Users to Excel | |||
| Auto fill color change | Excel Discussion (Misc queries) | |||
Linear Mode
