Tutorvo

Counting Leave Days: Custom Rest Days & Public Holidays with NETWORKDAYS.INTL

Lesson 3 of 816 minLab

This lesson is part of the course

In this lesson

You count how many working days each leave request really costs, given each person's own rest days and the public holidays, find the date they are back at work and flag requests that exceed the balance.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Annual Leave Entitlement: Service Tiers, Joiners, Leavers & Half DaysLab15 min Locked
  2. Accruals, Balances & the Carry-Over CapLab15 min Locked
  3. Counting Leave Days: Custom Rest Days & Public Holidays with NETWORKDAYS.INTLLab16 min Locked
  4. Holiday Liability: What Unused Leave Is Worth, by Cost CentreLab15 min Locked
  5. Absence Patterns: Spells, Days & the Bradford FactorLab16 min Locked
  6. Shift Rota Coverage: Staff per Shift vs Minimum StaffingLab16 min Locked
  7. Overtime & Premium Hours: Nights, Weekends and the Weekly ContractLab17 min Locked
  8. Capstone: Team Leave Calendar, Daily Overlaps & the Busiest DayLab18 min Locked