View Single Post
 
Old 08-15-2011, 11:50 AM
newton.rogers newton.rogers is offline Windows XP Office 2003
Novice
 
Join Date: Aug 2011
Location: Newcastle
Posts: 6
newton.rogers is on a distinguished road
Default 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?
Reply With Quote