Forum Discussion
Solved
Sequential dates in cells that are not next to each other
Hello, I am creating a spreadsheet for my team which is used for staffing and needs to have each individual day from 1st sept 23 to 31st august 24. I know Excel has an autofill for dates but these cells are not next to each other although they are in the same row.
Is there any way that I autofill these dates?
Enter the first seven days manually.
Select the range, including three empty cells to the right of the seventh day (since you have three empty cells between the days).
Use the fill handle to fill to the right.
2 Replies
Enter the first seven days manually.
Select the range, including three empty cells to the right of the seventh day (since you have three empty cells between the days).
Use the fill handle to fill to the right.
- Thank you!
