View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Viquar[_2_] Viquar[_2_] is offline
external usenet poster
 
Posts: 2
Default searching in the list of dates

Try the following function
=NETWORKDAYS(A2,B2,C3:C14)

Where cell A2 holds the start date (or the lower date)
B2 holds the end date
and the Column C from range C2:C14 holds the holidays.

To use this function you must have the Analysis ToolPack add-in
installed. Click Tools-- Addins -- Select Analysis Toolpack.