NETWORKDAYS Arguments

4. Try it: Edit the NETWORKDAYS

Edit the Start_Date: A2.

Edit the End_Date:G2


You should see a preview of the data to the right of the Arguments.
Click OK.

5. Try This, Too: AutoFill the Formula
Use the AutoFill handle to fill down this formula in Column H.

 

Memo to Self: The date that is displayed in the Preview is a SERIAL NUMBER. After you edit the Arguments, the work days will be displayed as a whole number.

Formulas->Function Library-> Date & Time->NETWORKDAYS

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: DATE Functions NETWORKDAYS