Calculate days, but exclude weekends

[mcvpjd3]

Just being lazy (efficient?) here, has anyone got a bit of script for calculating the number of days between 2 dates, but excluding weekends?

Thanks

[stanl]

If you have Office Installed just call the WorkSheetFunction NetWorkDays(). It even has an optional argument to exclude holidays between 2 dates.

[hdsouza]

You can loop through each day during the period
Then with the Timedate() function  if the first item == "sat" or == "sun"  dont count that day

[Deana]

Here are some possible algorithms you can use: http://stackoverflow.com/questions/1617049/calculate-the-number-of-business-days-between-two-dates. The would simply need to be converted to WIL code.