In my sample spreadsheet, I started at A2 with a date.
I would like to skip the next 10 cells down, then put the next date.
This is a week project, so by just putting the first date of the week it will fill in the rest of the column.
I would appreciate any suggestion or solution to this. Thank you.
DATE with skipped cells.ods (12.3 KB)
The simplest way is to select cells A2:A12 and drag down. A13 will be filled with the next date, then A 24, etc.
Or you could enter =A2+1 in cell A13 and format it, then copy that cell to A24, A35 etc. and save the sheet. Duplicate it every time you need a new sheet and enter the new date in cell A2, the others will fill adding from the new date entered
EarnestAI, thanks. I like the second suggestion better, works fine.