Hi - Dave here.
Happy Friday!
One of the new functions in Excel is SEQUENCE, which is designed to generate
numeric sequences.
At first glance, you might wonder how you can use a function like this. Sure, you can use SEQUENCE to generate the numbers 1-10, or even 1-100, but what else?
Well, one of the most useful applications for SEQUENCE is dates. Dates in Excel are just numbers, so you can use SEQUENCE to create a dynamic list of dates, as seen in the worksheet below:
[
Download the workbook and read the full explanation]
This is an easy problem in the current version of Excel, which offers the SEQUENCE function. In an older version of Excel without SEQUENCE, you can use a simple formula like =D5+1, copied down manually. The attached worksheet contains formulas for both options. Click the link above to read the full explanation and download the workbook.
Excel formulas
We maintain a list with over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
