Formula to return dates into specific cell on another sheet

I have attached an example worksheet for your viewing.

If you look at Sheet2 I would like to have a formula that looks at cells d3:l7 and if it finds it to have a number in that cell then it looks to the date above that column in (D1:L1) and places that date into Sheet1 under column c on the correct line.

EX1: On DIR - Operational -- it has days 9/6 thru 9/9 checked on sheet 2
I would like the formula to return 9/6, 9/7, 9/8, 9/9 into cell C3 on sheet1

IF it could group the dates into a format like 9/6 - 9/9 it would be great I just need to show the dates of service in that column.

Also sometimes we skip a couple days and then start up later in the same line so dates sometimes are would be 9/6 - 9/9, 9/15 - 9/28

Can this be done

Perhaps something like this? Please find file attach

Thanks

Hey that is great I am on the right track. I attached my complete workbook and since you know how the smaller one was working this should be ok for you to understand better. I like the first formula how it groups it into one column.

You can see the dates of service is on the Job Ticket sheet. But how do I extend this to the entire sheet on the Daily Chgs sheet to cover al the days?

I can carry the formula down the sheet How do I adjust formula from the 9 days... to I think about 60 days on the sheet.

Also you can see how some times you may skip a date with in certain time frame so how would that be represented in the answer. We would only usually use (9/5 -9/9 , 9/12-9/25)

so how would it come out when a few days are left out

Again thanks alot

Thanks for your help

Your solution is a little different than the other.... are you able to see the more complete worksheet to get a better feel how It looks and see if there would need to be any modifications for your VBA to work. I attached the worksheet titled "job ticket #3 v5 trial"

Thanks for your help.

I am not sure if you looked at the other sheet but I have entered that formula but the date ranges are coming in incorrect you can see the date ranges are 9/5-9/9 & 9/12

The range coming in from formula is 9/5 - 9/1 how can I fix this?

I am a little closer to getting it correct.
I attached the trail B sheet that has your formula in it.

Can you please direct my in the right direction.