Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. /
  3. Date functions

NETWORKDAYS practice: working days to resolve 150 support tickets

  • Intermediate
  • ~7 min
  • Date functions

The support team's SLA is measured in working days, not calendar days. The Tickets sheet lists 150 tickets closed in 2026 with the date each was opened and resolved; 18 arrived on a weekend and 6 were closed the same day. The Holidays sheet holds the 12 company holidays of 2026, and 28 tickets were open across at least one of them. Count the working days from the opened date to the resolved date (both days included) in F2:F151, excluding weekends and the holidays.

What you need to do

  1. 1Click F2 on the Tickets sheet and type =NETWORKDAYS(D2,E2, — then switch to the Holidays sheet and select A2:A13. Press F4 (Windows) or ⌘T (Mac) so it reads Holidays!$A$2:$A$13, close the bracket and press Enter.
  2. 2F2 shows 3 for TCK-24001 (opened 2026-01-05, resolved 2026-01-07): 3 calendar day(s), of which only 3 are working days.
  3. 3Fill F2 down to F151 (double-click the fill handle, or select F2:F151 and press Ctrl+D / ⌘D). Because the holiday range is locked with $, every row still reads the same list.
  4. 4Spot-check: a ticket opened and resolved on the same weekday shows 1 (both ends count), one opened on a Saturday and resolved on the Sunday shows 0.

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedIn F2, use NETWORKDAYS to count the working days from the opened date (D2) to the resolved date (E2), both included, skipping weekends and the holidays listed in Holidays!A2:A13; then fill down to F151.

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

About this exercise

A 162-row dataset on 2 sheets, one answer cell, about 7 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.

How to solve it

  • F2=NETWORKDAYS(D2,E2,Holidays!$A$2:$A$13)

NETWORKDAYS(start, end, holidays) counts the days from the start date to the end date that are not Saturdays, Sundays or dates in the holidays list — both the start and the end day are included, so a ticket opened and closed on the same Tuesday counts as 1. The holidays argument is optional, but leaving it out silently over-counts every ticket that was open across a holiday; the list on its own sheet is what keeps the number honest. Locking that range as Holidays!$A$2:$A$13 lets the same formula fill down 150 rows.

Pitfall 1: forgetting the third argument — 122 rows still come out right, which is why the mistake survives review; the grader catches it because 28 rows differ. Pitfall 2: "inclusive" counting — NETWORKDAYS gives 1 for same-day resolution and 5 for Monday to Friday; if the SLA counts elapsed working days instead, subtract 1 (and guard same-day tickets with MAX(0,…)). Pitfall 3: a start date after the end date returns a negative count rather than an error; a text date in the holiday list is ignored silently, so keep that column as real dates. NETWORKDAYS.INTL(start,end,weekend,holidays) handles other weekends: 7 for Friday–Saturday, "0000011" as a 7-character string for a custom pattern; the plain function always assumes Saturday and Sunday. WORKDAY is the inverse: WORKDAY(D2,5,holidays) returns the due date five working days after the opening date — the usual way to compute an SLA deadline. Whole-column references (Holidays!A:A) work and survive additions to the list, but a named range (Formulas → Define Name → Holidays2026) reads better and is less error-prone than a hard-coded $A$2:$A$13.

Other ways that work

  • =NETWORKDAYS.INTL(D2,E2,1,Holidays!$A$2:$A$13) — same result; 1 = Saturday/Sunday weekend
  • =NETWORKDAYS(D2,E2,Holidays!A:A) — whole-column holiday reference, grows with the list
  • =NETWORKDAYS(D2,E2,Holidays!$A$2:$A$13)-1 — elapsed working days, if your SLA excludes the opening day

Common mistakes

Omitting the holidays: =NETWORKDAYS(D2,E2) matches the answer for 122 tickets and is one or two days too high for the 28 tickets that were open across a company holiday.

How we grade

Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.

Answers computed with Excel 365 rules and checked in our grading engine on November 16, 2026. Author: GridBelt team.

In these programs

  • Excel test in 7 days, Level 3 planDay 3
  • Excel for Data AnalystsDay 7
  • Excel for Administrative AssistantsDay 9

Related exercises

  • Days to deadline and tenure in years (TODAY, DATEDIF)Beginner, ~6 min
  • Invoice due dates with EOMONTH and EDATEIntermediate, ~6 min
  • Turn text dates into real dates and group by monthExpert, ~12 min

Function reference

Official documentation

Next exercise

Turn text dates into real dates and group by month