Microsoft Excel – number of working days between two dates

The number of weekdays between two dates can be calculated using the Networkdays function.

Click in the cell where the answer goes and then, on the Formula bar, click the Insert Function
Fx button. The Insert Function dialog box will be displayed.

From the Or select a category drop-down list, select Date & Time. In the Select a function list, click on the NETWORKDAYS function and click OK.

The Function Arguments dialog box appears. In the Start_date entry type in the cell reference of the earlier of the two dates, then in the End_date field, type in the cell reference of the later date. Click OK. The numbers of working days is calculated and displayed.

Optionally, it is possible to specify a range holiday dates when using the NETWORKDAYS function. This allows the calculation of the number of working days between two dates. Should you have to do this regularly, then you may want to consider keeping a spreadsheet containing an up-to-date list of holidays and referencing this.

Find more information about our Microsoft Excel training courses London, UK or our Microsoft Excel training courses Dorset, Wiltshire, Hampshire.

Find more information about our Microsoft Excel training courses Sydney, Australia.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 and tagged , , , . Bookmark the permalink.

One Response to Microsoft Excel – number of working days between two dates

  1. Shannonside Training Solutions Ltd says:

    Reblogged this on Shannonside Training Tips.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s