Because this topic is now active again, and you are answering a distinct question, here goes the full flow:
Use DiffDays to get how many days exist between the two dates. Do Trunc of the difference by 7 to get the number of full weeks.
Weeks = Trunc(DiffDays(Date2,Date1)/7)
Now you have saved a few calculations.
For the final 0 to 6 days, just test if they are working days or weekends and add them to whichever variable is suitable.
Advance to the next day and repeat.
