I am trying to integrate a macro in a networkday function where the user will
be prompt to enter data for the formula. For example:
networkdays(A2,A3,B2:B5) as you know A2 is the start date, A3 the end date
and B2 through B5 are the holidays to be excluded. I want to write a macro
with conditional formulas that will prompt the user (maybe a window) to enter
Start Date, End Date and autimacally select the range for the holidays
(holidays are already sorted by date in column B) from column B depending on
the Ending Date. Tell me if this is possible.

Thanks.