Forum Discussion
Solved
Auto Generate a Timeline Based off Start and End Dates
Good Day All!
Is there a way to enter a start date and end date (C2,C3) and have excel generate a table automatically that reflect all of the dates between start and end?
I have posted a picture to show the rough idea.
With modern Excel, use the SEQUENCE function.
3 Replies
Not sure I understand. B2 and B3 contain no dates. So, the formula C5 will not spill a sequence.
This is fantastic!! Works perfectly.
But it makes me wonder... Can I somehow use SEQUENCE to add columns to an existing table? In the pic below I would like to extend the columns in the table as the sequence generates the dates according to B2 and B3.
Is this possible?
With modern Excel, use the SEQUENCE function.
