ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   NETWORKDAYS FUNCTION (https://www.excelbanter.com/excel-programming/342013-networkdays-function.html)

Welby

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