How to use Microsoft 365’s dynamic array function SEQUENCE() to create a list of dates in Excel

Microsoft Excel’s new dynamic array functions make complex calculations easier than ever before.

Image: PixieMe/Shutterstock

Microsoft 365 updates the way Excel handles dynamic functions. If you’ve ever entered an expression using Ctrl + Shift + Enter, then you’re already familiar with how Excel used to work with dynamic arrays. Thanks to the new dynamic array functions, these types of expressions are much easier to create and maintain. You enter the function as you normally would—with a simple Enter, and the results spill into the cells below, filling as many as necessary to complete the function’s calculations. In this article, I’ll show you how to create a sequence of dates that’s easy to create and update thanks to SEQUENCE().

SEE: 83 Excel tips every user should master (TechRepublic)

I’m using Microsoft 365…

Keep reading the full content on the TechRepublic site.

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Spread the love

Leave a Comment