Tip Printed from ExcelTip.com

---

Calculating the Number of Business Days in a Specified Period


Problem:

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