How to calculate Total Working Hours (8 per day) for Whole month excluding Saturday-Sunday Weekend ?
How to calculate Total Working Hours (8 per day) for Whole month excluding Saturday-Sunday Weekend ? What is the formula to be used?
Forum Discussion
The next month would be
8*
WeekDaySub(LastDayOfMonth(AdjustMonth(Today(),1)),AdjustMonth(FirstdayOfMonth(Today()),1))
and then put a 2 for 2 months ahead.
8*
WeekDaySub(LastDayOfMonth(AdjustMonth(Today(),1)),AdjustMonth(FirstdayOfMonth(Today()),1))
and then put a 2 for 2 months ahead.