Excel Dates & Times: DATE, EOMONTH, NETWORKDAYS, Time Math & Schedules
Master serial dates, DATE and TEXT, EDATE and EOMONTH, NETWORKDAYS and WORKDAY with holidays, DATEDIF and YEARFRAC, week numbers, overnight shifts, overtime timesheets and a project schedule in 8 hands-on labs, every cell checked instantly.
The first 2 lessons are free — no account needed.
About this course
An Excel date and time functions course built on one facility-services company's tickets, contracts, timesheets and projects, for office staff, schedulers and analysts who still count deadlines on a calendar. You see how Excel stores dates as serial numbers and label them with DATE, YEAR and TEXT, set renewal dates, month-end due dates and fiscal periods with EDATE and EOMONTH, turn an SLA into a due date with WORKDAY and count working days with NETWORKDAYS, holidays and custom weekends included, calculate age, tenure and a pro-rata bonus with DATEDIF and YEARFRAC, build a weekly revenue report with WEEKDAY and ISOWEEKNUM, handle overnight shifts with MOD and ×24, split a timesheet into regular and overtime pay and chain a project schedule into a Gantt-style chart. The first two labs are free.
Lessons
- How Excel Stores Dates: Serial Numbers, DATE, YEAR & TEXTFree
- EDATE & EOMONTH: Renewals, Due Dates & Fiscal PeriodsFree
- NETWORKDAYS & WORKDAY with Holidays and Custom Weekends Pro
- DATEDIF & YEARFRAC: Age, Tenure and Pro-Rata Amounts Pro
- WEEKDAY, WEEKNUM & ISOWEEKNUM: A Weekly Revenue Report Pro
- Time Math: Hours Worked, Overnight Shifts, MOD & ×24 Pro
- Weekly Timesheet: Regular Hours, Overtime & Pay Pro
- Project Schedule: WORKDAY Chains & a Gantt-Style Bar Chart Pro