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. How to get a date sequence in Excel with a formula.

Fill a series of dates with a specific step.Fill a column with weekdays, months or years.This tutorial takes an in-depth look at both methods so that you can choose the one that works best for you. The introduction of the new dynamic array SEQUENCE function has made it possible to make a series of dates with a formula too. Until recently, there has been just one easy way to generate dates in Excel - the AutoFill feature.

The tutorial shows how you can leverage the new SEQUENCE function to quickly generate a list of dates in Excel and use the AutoFill feature to fill a column with dates, workdays, months or years.

I work 08 serial number