Re: Workdays between dates? (OH HOW I HATE DATES)

2008-03-05 Thread Mark Morris
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

Re: Workdays between dates? (OH HOW I HATE DATES)

2008-03-05 Thread James Cicenia
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