lookup dates and return corresponding data
Columns A - "In date" B - "Out Date" & C contains the the "Networkdays",
column d is a gap column, column e is the Start date column and column f is the End date column, column g a gap column and columns H, I and J the returned data. I hope this makes sense. I have got a little further in solving this by using advanced filtering but is there any other method one could use by only using formulas?
|