If you want to fill sequential dates in your worksheet cells, you don’t need to type them manually. Microsoft Excel provides two ways to quickly and automatically fill dates into cells of your choice. We will show you how to use these methods.
In both of these methods, you type the first date into a cell in your spreadsheet. Then, based on that date, Excel automatically fills the other cells with sequential dates. You get the same results regardless of the fill method used below. However, the Fill Command method allows you to control the counted date unit.
HOW TO USE EXCEL’S DATEVALUE FUNCTION
Use fill handle to autofill dates in Excel
With the fill handle, you drag the first date over all the cells where you want to add dates. Excel fills these cells with sequential dates.
To use this method, in your spreadsheet, click the cell that contains a date. If you don’t already have one, type one, such as today’s date.
From the bottom right corner of the selected cell, drag down all the cells you want to insert dates into.
Drag the date cell down.
The selected cells now contain sequential dates.
The dates fill in automatically.
And you are ready.
Fill sequential dates in Excel using Fill command
Using the Fill command, you tell Excel your first date and the cells in which you want sequential dates. The command then fills the specified cells with sequential dates.
To use this command, in your spreadsheet, select your date cell as well as the cells where you want sequential dates.
Select the date and other cells.
With your cells highlighted, in Excel’s ribbon at the top, click the “Home” tab. Then, in the “Edit” section, choose Fill > Series.
Select “Series” from the menu.
In the “Series” box, in the “Date unit” section, choose the unit you want to fill in your cells. Then click “OK”.
Back on the worksheet, you’ll find that Excel has filled your selected cells with the dates.
The dates have been filled in automatically.
This is how you eliminate the hassle of manually entering dates into your Excel spreadsheets. Very convenient !