Sequential dates in cells that are not next to each other

[HelenChadwick]

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? 

[#2 · Accepted 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.

[#3]

Thank you!