Create Macro to Calculate Workdays Between two Dates

[boldcode]

Hi,

I want to calculate the Net Work Days between two dates as well as excluding holidays between those two dates. I created a holiday list in a worksheet named "holidaylist" in the workbook "DosExample".

I am able to do this using the following excel formula:
=NETWORKDAYS(K2,L2,holidaylist!$A$2:$A:$A95)...K2 is the start date and L2 is the end date...and displaying the results in J2 through the rest of the cells. This formula works great and is exactly what I want, but since I could have up to 20,000 records I really don't want to copy and paste the formula for the rest of the cells.

I want to use a macro that can populate the correct results in J2 and the rest of cells (the range can vary) by using the formula I described above.

In the workbook attached to this post I have worksheets:
1. holidaylist
2. Data Before Macro is Executed
3. Data After Macro is Executed

If you need me to clarify something just let me know.

- BC