How to get the total number Saturdays and Sundays from a given duration
In a report where a turn around time is computed, we need to deduct the total number of Saturdays and Sundays.
For example:
Created Date: September 1, 2013
Completion Date: September 16, 2013
The total days it was opened is 15 days.
September 7, 8 are Saturdays, and 14, 15 are Sundays, hence 4 days should be deducted from 15 days.
The final turn around time should then be 11 days.
Anyone know how do we accomplish this?
Many thanks!
For example:
Created Date: September 1, 2013
Completion Date: September 16, 2013
The total days it was opened is 15 days.
September 7, 8 are Saturdays, and 14, 15 are Sundays, hence 4 days should be deducted from 15 days.
The final turn around time should then be 11 days.
Anyone know how do we accomplish this?
Many thanks!
0