When does this project actually finish?
Real problems with no formula named for you. You decide what to use.
This project tracker lists who owns each project, which isn't needed here. Using the start date and the number of working days needed, find the actual calendar date the project finishes: weekends don't count toward the work.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Project | Owner | Start Date | Business Days Needed |
| 2 | Website Revamp | Priya | 2026-03-02 | 15 |
| 3 | Finish Date |
This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.
Why this one matters
Real project trackers almost always give a start date and a duration in working days, not calendar days: getting the finish date right means knowing which function counts business days instead of raw ones.
More case studies
Case Studies are part of the full unlock
Case Studies are locked until you unlock the full site: real, messier problems with no function named for you, graded the same way every Practice exercise is. Open this one to see how to unlock the rest.
Open this case study →