GET GOOD WITH WORK SHIRT
Data Practice Lab
Excel Intermediate Math & Logic Practice
1. Select Office Task
Project Timelines (Dates)
Service Category Billing (Logic)
2. Office Records
Test Intermediate Functions
← Change Task
3. Calculation Results
=NETWORKDAYS(start_date, end_date)
Calculate the actual working days (excluding weekends) for all projects.
Calculate Billable Days
=SUMIF(range, criteria, sum_range)
Filter by Service (e.g. "Audit" or "Legal"):
Sum Billable Hours
← Restart Lab