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)