---
title: "Excel Tips and Tricks: Workdays"
description: "Business Reporting Question: How can I calculate the number of workdays between two dates?"
image: https://www.positivevision.biz/hs-fs/file-17345939-jpg/images/excel_tips_-_workdays_option_1.jpg
---

[![PositiveVision ](https://www.positivevision.biz/hubfs/images/Positive_Vision_Logo_tagline_2015_xsm-1.jpg "Positive_Vision_Logo_tagline_2015_xsm-1")](https://www.positivevision.biz/)

# Business Automation and Software Blog

# Excel Tips and Tricks: Workdays

Posted by [Robert Baran](https://www.positivevision.biz/blog/author/robert-baran) on Fri, Nov 23, 2012 @ 01:16 PM

- [Tweet](https://twitter.com/share)

******Excel Tips and Tricks / Business Reporting Question: ** How can I calculate the number of workdays between two dates? The usual off days are Saturday, Sunday and public holidays.

**Answer: **By using the Networkdays function

**Why: **To calculate the number of workdays between two dates

**Applies To: Excel (2010, 2007):**

1. The data below will be used for illustration purposes:

![Excel Tips and Tricks](https://www.positivevision.biz/hs-fs/file-17345939-jpg/images/excel_tips_-_workdays_option_1.jpg?width=254&height=153&name=excel_tips_-_workdays_option_1.jpg)

2. Select cell A7.

3. Select **F****ormulas**>**D****ate **& **T****ime**>NETWORKDAYS**. **Refer to the screen shot below:

![Excel Tips and Tricks](https://www.positivevision.biz/hs-fs/file-17346111-jpg/images/excel_tips_-_workdays_option_2.jpg?width=384&height=300&name=excel_tips_-_workdays_option_2.jpg)

 4. Enter as below and select **Ok.**

**![Excel Tips and Tricks](https://www.positivevision.biz/hs-fs/file-17346525-jpg/images/excel_tips_-_workdays_option_3.jpg?width=437&height=227&name=excel_tips_-_workdays_option_3.jpg)

**The number of workdays between the two given dates is **78. **The formula can also be entered in this way:

**=NETWORKDAYS (A3,A4,A5:A6). **The formula subtracts the usual weekend days and any specified holidays from the difference between the start and end dates of the project.

[![Contact PositiveVision ► ► for a Complimentary  Reporting Consultation](https://no-cache.hubspot.com/cta/default/133208/8610a6e6-e31a-4280-a6e7-b741b3e0dfdb.png)](https://cta-redirect.hubspot.com/cta/redirect/133208/8610a6e6-e31a-4280-a6e7-b741b3e0dfdb)

 Topics: [Business Reporting](https://www.positivevision.biz/blog/topic/business-reporting), [Excel Tips and Tricks](https://www.positivevision.biz/blog/topic/excel-tips-and-tricks)

### Subscribe via Email

### Latest Posts

<https://www.youtube.com/channel/UCWmme9JYZ0Gf6MDQeRXSBww?sub_confirmation=1><https://www.linkedin.com/company/2516562><https://twitter.com/PositiveVision_>

![authorized_solution_partner_w_logo@3x](https://www.positivevision.biz/hs-fs/hubfs/authorized_solution_partner_w_logo@3x.png?width=150&name=authorized_solution_partner_w_logo@3x.png)![Sage Partner Transparent Square](https://www.positivevision.biz/hs-fs/hubfs/Sage%20Partner%20Transparent%20Square.png?width=144&name=Sage%20Partner%20Transparent%20Square.png)    © 2019 PositiveVision • 219 E. Thorndale Ave. Roselle, IL 60172 

800.559.1323 •  [E-mail](mailto:contact@positivevision.biz) • [Privacy Policy](https://www.positivevision.biz/privacy-policy/) • [Sitemap](https://www.positivevision.biz/sitemap/)

 

 

 

 

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Robert Baran",
    "url" : "https://www.positivevision.biz/blog/author/robert-baran"
  },
  "datePublished" : "2012-11-23T19:16:00.000Z",
  "headline" : "Excel Tips and Tricks: Workdays",
  "image" : [ "https://www.positivevision.biz/hs-fs/file-17345939-jpg/images/excel_tips_-_workdays_option_1.jpg" ],
  "mainEntityOfPage" : {
    "@id" : "https://www.positivevision.biz/blog/bid/165281/Excel-Tips-and-Tricks-Workdays",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "None"
    },
    "name" : "PositiveVision"
  }
}
```