Date after ten working days
Which date is ten working days after kickoff in F2? Show it as text in yyyy-mm-dd form.
Formula: =TEXT(WORKDAY(F2,10),"yyyy-mm-dd") → 2024-09-16
Hands-on Excel exercises
Excel Skills for Project Managers
Practice Excel for project managers: working days with NETWORKDAYS, deadlines with WORKDAY, and on-track or behind status flags, with answers.
Project managers use spreadsheets as a plan and a warning light: how many working days are left, when does this task finish if it takes ten working days, and which items are behind? Skill tests for the role emphasize dates that skip weekends, simple status logic, and a summary the team can read at a glance.
The live sheet has a kickoff date and a launch date, with a short task table that holds the planned and actual percent complete. Your task is to count the working days between kickoff on 2 September 2024 and launch on 27 September 2024 with NETWORKDAYS. The worked answers add a finish date ten working days after kickoff using WORKDAY, a status flag with IF, and a count of tasks that are behind plan.
Dates are numbers, so decide whether a start date counts as a working day and say so. Calendars with holidays need a holiday range as an extra argument. A status rule such as behind when actual is below planned should be written once and applied to every row, not retyped. Keep one task per row so filters and counts stay correct. For budget and cost summaries, the financial analysts page extends the same habits, and the administrative assistants page covers lists and scheduling basics.
Your turn
Your turn: in G2, count the working days from the kickoff date in F2 to the launch date in F3, both included, ignoring holidays.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Planned % | Actual % | Milestone | Date | ||
| 2 | Design | 100 | 100 | Kickoff | 9/2/2024 | ||
| 3 | Build | 60 | 45 | Launch | 9/27/2024 | ||
| 4 | Test | 30 | 30 | ||||
| 5 | Docs | 20 | 5 | ||||
| 6 |
Not yet solved.
Answer: =NETWORKDAYS(F2,F3)
Practice under a time limit
Try the free Sample mock exam with 4 tasks in 8 minutes, or browse the level and interview mock exams included with Pro + Exams.
Related exercises
Open a task in its lesson.
- In H2, calculate how many days there are from the date the first order was placed (B2) to the year end (G2).
- In C2:C8, write "Pass" if the score is at least the passing score (F1), otherwise "Fail".
- Allow only whole numbers from 1 to 5 in D2:D7.
- In F2, calculate the total of Emma's deals in Boston.
- Show the structure of expenses as a pie chart (E1:F5).
- In E2:E7, write "Over budget" if the variance is above zero, otherwise "Within budget".
- In F3, calculate the revenue for the month chosen in F1 and format the cell as currency.
Worked answers
Try the spreadsheet first, then compare your formula and result.
Status flag for one task
Return Behind if the actual percent in C3 is below the planned percent in B3, otherwise On track.
Formula: =IF(C3<B3,"Behind","On track") → Behind
Count tasks behind plan
How many tasks have an actual percent below the planned percent?
Formula: =SUMPRODUCT((C2:C5<B2:B5)*1) → 2
Frequently asked questions
Does NETWORKDAYS count the start date?
Yes, both the start and end dates are counted when they are working days.
How do I add holidays?
Add a range of holiday dates as the last argument of NETWORKDAYS or WORKDAY so they are skipped.
What if my weekend is not Saturday and Sunday?
Excel has variants of both functions with custom weekend settings. This page practices the standard Monday to Friday week.
Why keep one task per row?
Filters, counts, and charts depend on it. Merged or multi-task rows break them.