Automatically create table based on data range

[willmeister]

I was hoping to find a way to do this without VBA or macros. I have a start and end date in cells A1 and A2 and I want a table built with the appropriate number of rows based on those dates.

The smallest date range there would ever be is one week so I don't mind building a table with 7 rows. But if i change the date range to say 14 days, I'd want the table to add 7 rows automatically.

Is this even possible?

Thank you.

[JBeaucaire]

With no VBA, then you would have to have formulas in all the cells that might ever be a part of the resulting table. IF that's OK, then post a workbook showing the layout of the "resulting table" formed by your start/end dates so we can see it all clearly.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.