Return to site

Macro to change the format of a date in the header of excel for mac

broken image
broken image
broken image

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.