Networking days are important for both an employee and the employer. In todays post we will see how NETWORKDAYS can be calculated in Excel. MS Excel has some built in formulas to calculate network days.
In Excel 2010, we have following formulas available for calculating networking days.
NETWORKDAYS
NETWORKDAYS.INTL
Both these formulas have a little different syntax. We will take them up one by one and see how they can be used to find networking days.
The NETWORKDAYS () Formula:
The NETWORKDAYS () takes three arguments to calculate the working days i.e. a start date, an end date and an optional argument that consists of holidays, if you want them to be subtracted from the working days.
The Syntax is like following: