I am a recent graduate working as an Junior engineer/project manager. I am very familiar with Excel; however there is still much to learn, and I've been using it extensively. I am wanting to auto size a table based on values in two cells. I've found myself wanting to do this in several instances, but would like some guidance on how I might accomplish this. In this case I have a clean table with 5 rows and a date column. I'd like to enter a start and end date in two cells outside of the table and have the rows expand and fill the date column with all of the dates from start to end referencing the two cells with entered dates. I have formulas in the adjacent cells that I would also like to populate as if I were hitting tab on the bottom right corner.

Thank you, Jovanni Rabelo