To avoid mistakes, you can supply the date by using the DATE function such as DATE(2020, 8, 1). Start - the starting date in the format that Excel can understand, like '' or ''.

Columns - the number of columns to fill with dates.Rows - the number of rows to fill with dates.All you have to do is to correctly configure the arguments as explained in the following examples. Because internally in Excel dates are stored as serial numbers, the function can easily produce a date series too. In one of the previous tutorials, we looked at how to use the new dynamic array SEQUENCE function to generate a number sequence. How to make a date sequence in Excel with a formula In the Series dialog box, select the Date unit of interest and set the Step value.įor more examples, please see How to insert and autofill dates in Excel.In the pop-up menu, choose Series (the last item).Select that cell, right-click the fill handle, drag it through as many cells as needed, and then release.Enter the initial date in the first cell.To auto generate a series of days, weekdays, months or years with a specific step, this is what you need to do: When you release the mouse button, a context menu will pop-up letting you select the needed option, Fill Years in our case:įill a series of dates incrementing by N days Or you can enter your first date, right-click the fill handle, hold and drag through as many cells as needed.After that, click the AutoFill Optionsbutton and pick the desired option, say Fill Months: Fill a column with sequential dates as described above.

To create a series of workdays, months or years, do one of the following: Select the cell with the initial date and drag the fill handle (a small green square at the bottom-right corner) down or to the right.Įxcel will immediately generate a series of dates in the same format as the first date that you typed manually.įill a column with weekdays, months or years.Type the initial date in the first cell.

Auto fill a date series in Excelįilling a column or row with dates that increment by one day is very easy: When you need to fill a column with dates in Excel, the fastest way is to use the AutoFill feature.

Avery templates for mac word