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
Bookmarks