Date Range Formula

[hoskinsw1]

Hello,

I am new to the forum and looking for some opportunities to enhance some sheets in excel. I am looking for a way to translate several date ranges to a list of dates in Excel.

Example from Sheet1:
Cell A1: 12/24 Cell A2: 12/28
Cell B1: 1/2 Cell B2: 1/18
Cell C1: 1/25 Cell C2: 1/26

On sheet2, list all dates between 12/24 & 12/28 then between 1/2 & 1/18, then 1/25-1/26 in separate rows such as:

Sheet2:
12/24
12/25
12/26
12/27
12/28
1/2
1/3
And so on...

Thank you!!!!!

 

[Rick Rothstein]

Welcome to the forum! I have some questions...

1. Are those real dates on Sheet1 formatted to display as month/day only or are those cells formatted as text and what you show us is all that is in them?

2. If they are real dates, does the output on Sheet2 have to be real dates displayed as month/day but with the correct underlying year (not shown)?