NETWORKDAYS & WORKDAY with Holidays and Custom Weekends
This lesson is part of the course
In this lesson
You set the SLA due date for eight work orders with WORKDAY, count the workdays they took with NETWORKDAYS, count Monday-to-Saturday crew days with NETWORKDAYS.INTL and flag late jobs, always skipping the closure days.
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
- How Excel Stores Dates: Serial Numbers, DATE, YEAR & TEXT Locked
- EDATE & EOMONTH: Renewals, Due Dates & Fiscal Periods Locked
- NETWORKDAYS & WORKDAY with Holidays and Custom Weekends Locked
- DATEDIF & YEARFRAC: Age, Tenure and Pro-Rata Amounts Locked
- WEEKDAY, WEEKNUM & ISOWEEKNUM: A Weekly Revenue Report Locked
- Time Math: Hours Worked, Overnight Shifts, MOD & ×24 Locked
- Weekly Timesheet: Regular Hours, Overtime & Pay Locked
- Project Schedule: WORKDAY Chains & a Gantt-Style Bar Chart Locked