0 of 62
Dates·Scenario·Lesson 51 of 62Pro

A clinic’s appointment book

A real-world job using what the Dates section covered.

What you’ll do

A small clinic’s bookings for February and March. The manager wants to know how long patients wait, how many don’t show up, and how long it’s been since the last appointment.

The steps

6 steps
  1. 1
    In F2, work out how many days the patient waited from booking to appointment. Fill it down to F13.
  2. 2
    In G2, count the working days of that wait, skipping weekends. Fill it down to G13.
  3. 3
    In J2, find the average wait in days, rounded to 1 decimal place.
  4. 4
    In J3, find the longest wait.
  5. 5
    In J4, count the patients who didn’t show up.
  6. 6
    In J5, work out how many days have passed since the last appointment in the book.

Scenario locked

Unlock the other 44 lessons for $49.99

Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.

Unlock for $49.99