Date Functions
Intermediate
WORKDAY Function
Calculate working days using WORKDAY.
Task:
You need to calculate the completion date of a project based on a start date and a number of working days. Calculate the completion date in column C based on the start date in column A and the number of working days in column B, excluding weekends.
Learning Objectives:
- Learn WORKDAY function
- Understand working day calculations
- Practice project scheduling
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Start Date | Working Days | Completion Date |
| 2 | 1/15/2023 | 20 | |
| 3 | 5/20/2023 | 15 | |
| 4 | 12/15/2023 | 10 |
What this exercise teaches (contains the answer)
WORKDAY function is useful for project management, scheduling, or resource allocation where you need to calculate dates based on working days.