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.

Until recently, there has been just one easy way to generate dates in Excel - the AutoFill feature. The introduction of the new dynamic array SEQUENCE function has made it possible to make a series of dates with a formula too.

Fill a series of dates incrementing by N days
To auto generate a series of days, weekdays, months or years with a specific step, this is what you need to do:

Enter the initial date in the first cell.
Select that cell, press alt + H + F + I + S
In the pop-up menu, choose Series (the last item).
In the Series dialog box, select the Date unit of interest and set the Step value.
Click OK.


#excel #msexcel #finance #dataentry #datascience #charteredaccountant #audit #easyexcel #excelshortcuts #excelshortsvideo #spreadsheet #corporate #row #excelnovice #shortcut #investmentbanking #dataanalysis #datascientist #dataanalyst #timesaving #audit #easyexcel #accounting #hr #humanresources #youtubeshorts #conditionalformatting #sequence #dates #series

свернуть