View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PetroffP
 
Posts: n/a
Default Use Vlookup to find less than today

Holidays are a problem in Excel, you would have to create a separate
lookup table of the holidays and factor it in. To just deal with
weekends, what about
=VLOOKUP(E4-CHOOSE(WEEKDAY(E4),2,1,1,1,1,1,1),'e1'!H:I,2,1)