Hi James,
Just looking at your list, you're getting what I would expect, i.e.
it's 4 days from Monday to Friday. But I think if you want the
calculation to be inclusive, it looks like you would always be safe in
adding one day to the end date before performing the calculation.
Regards,
M
Ok -
Here are the results of my test (noticed the * inconsistencies):
What I am trying to get:
June 1 - June 7 (Sunday - Saturday) 5 Work Days.
June 2 - June 6 (Monday - Friday) 5 Work Days
June 2 - June 9 (Monday - next Monday ) 6 Work Days
June 7 - June 9 (Saturday - Monday) 1 Work Day
Ju