Excel Dates & Times: DATE, EOMONTH, NETWORKDAYS, Time Math & Schedules

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Work with the service-ticket log of Kestrel Facility Services: count the days each ticket was open, pull out the year, label the month with TEXT and schedule a follow-up visit with DATE.
• Calculate renewal dates, end-of-next-month invoice due dates, calendar quarter ends and the fiscal year for Kestrel's eight maintenance contracts.
• 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.
• Calculate each employee's age and tenure on the report date, write the tenure as "years and months", turn it into decimal years with YEARFRAC and pay a pro-rata bonus.
• Give every March job a Monday-based weekday number, an ISO week number and the Monday its week starts on, then sum the revenue per week with SUMIFS.
• Calculate shift lengths that cross midnight with MOD, convert times into decimal paid hours, round them to the nearest quarter hour and show a total above 24 hours correctly.
• Split Ava Moreno's weekly hours into regular and overtime hours with MIN and MAX, calculate her daily pay with the overtime factor and chart the week as a stacked column chart.
• Schedule Kestrel's HVAC retrofit project: end dates from working-day durations, start dates that follow the previous task, calendar days per task and a bar chart of the schedule.