How to extract & list all dates between two dates in Excel

Imagine a situation in which you need to create a date-wise table. For example, you are creating a schedule where you need to mention a date-wise list of activities. In such a case, you would need a list of dates. Obviously, no list is unlimited, so your list would have a starting and ending date.

For such cases, you could use the method explained in this tutorial to obtain the list of dates between two dates as a list in a column. You have two ways to proceed:

1] Create a list of sequential dates in Excel using the Fill handle.

2] Obtain a list of all dates between two given dates in Excel using formula.

[judy]

I have a similar situation but the 2 dates, as in the 1st Jan and 11th Jan in your case, are in columns as opposed to rows. Can you help on this?