NETWORKDAYS FUNCTION

W

Welby

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert formula even cells with data below it 6
Networkdays by state whilst excluding each states public holiday andnational holidays 1
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Add-in WITH worksheets?? 1
returning a date 7 business day excluding holidays in the future 2
Calculate end date and time 1
networkdays alternative 2
find oldest date with a condition 4

Top