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. 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.
