» Calculating the Number of Business Days in a Specified Period
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Calculating the number of business days between the dates entered in cells A2 & B2.
Solution:
Use the NETWORKDAYS function as shown in the following formula:
=NETWORKDAYS(A2,B2)
Example:
Date1________Date2___________Business Days
01/04/2005___01/10/2005______131

Book Store:
Recommended Books:
- Special Edition Using Microsoft Excel 2002
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Marketing Planning for Services
- Financial Modeling - 2nd Edition
- Microsoft Outlook 2002 for Dummies
- Keys to Reading an Annual Report (Barron's Business Keys)
Reply: Fred G
Alan
Hi Fred,
[QUOTE=Fred G.]The real power of this function comes when one uses the optional third parameter. This parameter allows you to create a custom list of holidays, which are used in making the calculation. This makes it an international function, going far beyond ignoring weekends done in the basic function.
Surprised the "tip" author ignored this.[/QUOTE]I agree totally.
I would also add though that this function is not one I suggest using too often since it is, essentially, a UDF and requires that the add-in is installed.
Most (?) users don't have it installed and don't even know what an add-in is. They will just think that your spreadsheet doesn't work!
There is no *need* to use this function - it can be created from real core excel functions, but takes more work and is harder to 'read' afterwards.
There are always exceptions!
Alan.
Not working
Hans A
Hi, tried this but the result is:
date in date vic Days
04/06/2005 09/06/2005 #VALUE!
Can anybody tell me what I should do ?
Reply: Hans A
Alan
Hi Hans A,
[QUOTE=Hans A]Hi, tried this but the result is:
date in date vic Days
04/06/2005 09/06/2005 #VALUE!
Can anybody tell me what I should do ?[/QUOTE]If you enter this:
=NETWORKDAYS("4 Jun 2005","9 Jun 2005")
You should get a result of 4 (assuming you have the add-in installed).
HTH,
Alan.
Which Add-In?
mmcnown
[QUOTE=Alan]Hi Hans A,
If you enter this:
=NETWORKDAYS("4 Jun 2005","9 Jun 2005")
You should get a result of 4 (assuming you have the add-in installed).
HTH,
Alan.[/QUOTE]
Which Add-In is required for this function to work?
Add-in?
mmcnown
What add-in is required for this to work properly?
re: addin...
Tachyon
This function IS included in version 2.x versions and doesn't require any addins.
It's a simple, and useful function, especially for things like estimating pay, or total payroll projections etc.
davesexcel
Analysis toolpac
go to tools add-ins and select it


Surprised the "tip" author ignored this.