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.
|