Excel, Create a table, Reference cell, Start Date, End Date-CodePudding

I just want to create a table by reference of two cells. One of them will be start date and other one will be end date.

I want to create a table that has a reference to these two cells. If the start date is May 6 and the end date is May 11 then the table will automatically add necessary columns, for this 1st column of the table has May 6 date and the last column of the table has the May 11 date.

Also, if I change the start date and end date, the table should adjust by itself by adding or removing columns depending on the last date.

CodePudding user response：

Suppose you have 5-May-2022 in cell A1 and 11-May-2022 in cell B1. Then use below SEQUENCE() function-

=SEQUENCE(1,(B1-A1) 1,A1,1)