SOLVED

Sequential dates in cells that are not next to each other

Copper Contributor

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? 

 

HelenChadwick_0-1690884478201.png

 

2 Replies
best response confirmed by SergeiBaklan (MVP)
Solution

@HelenChadwick 

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.

HansVogelaar_0-1690884914816.png

 

1 best response

Accepted Solutions
best response confirmed by SergeiBaklan (MVP)
Solution

@HelenChadwick 

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.

HansVogelaar_0-1690884914816.png

 

View solution in original post