![]() |
NETWORKDAYS FUNCTION
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. |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com