---
title: "NETWORKDAYS, WORKDAY and WEEKDAY practice: 5 exercises with answers"
description: "Practice NETWORKDAYS, WORKDAY and WEEKDAY in Excel: count working days, set delivery dates and skip holidays in a live spreadsheet."
canonical_url: "https://excelsavvy.com/practice/networkdays-workday"
meta:
  "og:description": "Practice NETWORKDAYS, WORKDAY and WEEKDAY in Excel: count working days, set delivery dates and skip holidays in a live spreadsheet."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TkVUV09SS0RBWVMsIFdPUktEQVkgYW5kIFdFRUtEQVkgcHJhY3RpY2U6IDUgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgTkVUV09SS0RBWVMsIFdPUktEQVkgYW5kIFdFRUtEQVkgaW4gRXhjZWw6IGNvdW50IHdvcmtpbmcgZGF5cywgc2V0IGRlbGl2ZXJ5IGRhdGVzIGFuZCBza2lwIGhvbGlkYXlzIGluIGEgbGl2ZSBzcHJlYWRzaGVldC4%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlN0YXJ0IiwiRW5kIiwiV29ya2luZyBkYXlzIl19LHsibiI6MiwiY2VsbHMiOlsiTWFyIDQsIDIwMjQiLCJNYXIgMTUsIDIwMjQiLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii9wcmFjdGljZS9uZXR3b3JrZGF5cy13b3JrZGF5Ig%2Cs_AI1XRqnxRyOPo4jY.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "NETWORKDAYS, WORKDAY and WEEKDAY practice: 5 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TkVUV09SS0RBWVMsIFdPUktEQVkgYW5kIFdFRUtEQVkgcHJhY3RpY2U6IDUgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgTkVUV09SS0RBWVMsIFdPUktEQVkgYW5kIFdFRUtEQVkgaW4gRXhjZWw6IGNvdW50IHdvcmtpbmcgZGF5cywgc2V0IGRlbGl2ZXJ5IGRhdGVzIGFuZCBza2lwIGhvbGlkYXlzIGluIGEgbGl2ZSBzcHJlYWRzaGVldC4%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlN0YXJ0IiwiRW5kIiwiV29ya2luZyBkYXlzIl19LHsibiI6MiwiY2VsbHMiOlsiTWFyIDQsIDIwMjQiLCJNYXIgMTUsIDIwMjQiLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii9wcmFjdGljZS9uZXR3b3JrZGF5cy13b3JrZGF5Ig%2Cs_AI1XRqnxRyOPo4jY.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **NETWORKDAYS, WORKDAY and WEEKDAY practice exercises**

Count the working days between two dates, find the date a number of working days ahead, and tell which day of the week a date falls on.

[**Start the first exercise**](https://excelsavvy.com/practice/networkdays-workday/networkdays-working-days)

WEEKDAY(WORKDAY(

## **How NETWORKDAYS, WORKDAY and WEEKDAY work**

NETWORKDAYS counts the working days between two dates, Monday to Friday. WORKDAY goes the other way: give it a start date and a number of working days, and it returns the date that many working days later. Both can skip a list of holidays. WEEKDAY turns a date into a number for the day of the week.

With Mar 4, 2024 in A2 and Mar 15, 2024 in B2, `**=NETWORKDAYS(A2,B2)**` returns 10, because the start and end dates both count. With an order date of Mar 4, 2024 in A2 and 5 in B2, `**=WORKDAY(A2,B2)**` returns Mar 11, 2024. Add a range of holiday dates as the last argument, as in `**=NETWORKDAYS(A2,B2,E2:E4)**`, and those days are left out too. WORKDAY returns a date serial number, so format the cell as a date.

WEEKDAY counts Sunday as 1 unless you say otherwise. Give it 2 as the second argument and Monday becomes 1. If your weekend is not Saturday and Sunday, use NETWORKDAYS.INTL or WORKDAY.INTL. The exercises below cover counting working days with and without holidays, delivery dates with WORKDAY and numbering the day of the week.

1. [**1****Count working days with NETWORKDAYS**In C2, use NETWORKDAYS to count the working days, Monday to Friday, from the start date in A2 to the end date in B2.](https://excelsavvy.com/practice/networkdays-workday/networkdays-working-days)
2. [**2****Working days around Easter****Premium**The office is closed on the days in E2:E4. In C2, count the working days from A2 to B2 with NETWORKDAYS, and give it E2:E4 as the holidays.](https://excelsavvy.com/practice/networkdays-workday/networkdays-holidays)
3. [**3****Delivery date with WORKDAY****Premium**Delivery takes the number of working days in B2. In C2, use WORKDAY to find the delivery date for the order date in A2.](https://excelsavvy.com/practice/networkdays-workday/workday-delivery-date)
4. [**4****Day of the week with WEEKDAY****Premium**In B2, use WEEKDAY with 2 as the second argument to number the day of the week of A2, with Monday as 1.](https://excelsavvy.com/practice/networkdays-workday/weekday-day-of-week)
5. [**5****Delivery date over the holidays****Premium**The office is closed on the days in E2:E5. In C2, find the delivery date B2 working days after the order date in A2. Use WORKDAY and give it E2:E5 as the holidays.](https://excelsavvy.com/practice/networkdays-workday/workday-holidays)

## **Functions in this topic**

- [**WEEKDAY**](https://excelsavvy.com/functions/weekday)
- [**WORKDAY**](https://excelsavvy.com/functions/workday)

## **Read the guide**

- [**Excel for finance and accounting: the skills you actually use**](https://excelsavvy.com/learn/excel-for-finance)
- [**Dates in Excel: how they work and the formulas you need**](https://excelsavvy.com/learn/excel-dates)
- [**Excel calendar 2026: build your own with week numbers and holidays**](https://excelsavvy.com/learn/excel-calendar-2026)

## **Questions**

<details>

<summary>

### Why does WORKDAY show a number instead of a date?

</summary>

Excel stores dates as serial numbers, and WORKDAY returns one. The cell just needs a date format. Select it, open the number format menu on the Home tab and choose Short Date. The same goes for any formula that returns a date, such as EDATE or a date plus a number of days.

</details>

<details>

<summary>

### How do I count working days when the weekend is not Saturday and Sunday?

</summary>

Use NETWORKDAYS.INTL, which takes a weekend code as the third argument. =NETWORKDAYS.INTL(A2,B2,11) treats only Sunday as the weekend, and 7 makes Friday and Saturday the weekend. Holidays go in as the fourth argument. WORKDAY.INTL works the same way for delivery dates.

</details>

<details>

<summary>

### How do I get the name of the weekday from a date in Excel?

</summary>

Use =TEXT(A2,"dddd") to get the full name, such as Monday, or "ddd" for Mon. To keep the date and only change how it looks, format the cell with the custom format dddd. WEEKDAY on its own only returns a number, so it is not the tool for names.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/networkdays-workday#webpage","description":"Practice NETWORKDAYS, WORKDAY and WEEKDAY in Excel: count working days, set delivery dates and skip holidays in a live spreadsheet.","name":"NETWORKDAYS, WORKDAY and WEEKDAY practice: 5 exercises with answers","url":"https://excelsavvy.com/practice/networkdays-workday","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/networkdays-workday#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/networkdays-workday#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/networkdays-workday#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/networkdays-workday#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/networkdays-workday"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/networkdays-workday#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"NETWORKDAYS, WORKDAY and WEEKDAY practice: 5 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/networkdays-workday#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Why does WORKDAY show a number instead of a date?","acceptedAnswer":{"@type":"Answer","text":"Excel stores dates as serial numbers, and WORKDAY returns one. The cell just needs a date format. Select it, open the number format menu on the Home tab and choose Short Date. The same goes for any formula that returns a date, such as EDATE or a date plus a number of days."}},{"@id":"https://excelsavvy.com/practice/networkdays-workday#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I count working days when the weekend is not Saturday and Sunday?","acceptedAnswer":{"@type":"Answer","text":"Use NETWORKDAYS.INTL, which takes a weekend code as the third argument. =NETWORKDAYS.INTL(A2,B2,11) treats only Sunday as the weekend, and 7 makes Friday and Saturday the weekend. Holidays go in as the fourth argument. WORKDAY.INTL works the same way for delivery dates."}},{"@id":"https://excelsavvy.com/practice/networkdays-workday#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I get the name of the weekday from a date in Excel?","acceptedAnswer":{"@type":"Answer","text":"Use =TEXT(A2,\"dddd\") to get the full name, such as Monday, or \"ddd\" for Mon. To keep the date and only change how it looks, format the cell with the custom format dddd. WEEKDAY on its own only returns a number, so it is not the tool for names."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
