-
Select the range of cells to fill with the first cell containing the starting date.
-
Go to Home, select Fill and choose Series.
-
Choose the settings to use and select OK.
For more info, see Create a list of sequential dates.
Auto Filling isn't currently possible in Excel for the web. You can, however, Auto Fill a date in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.