Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.3  Apply Advanced Date and Time Functions: Use Functions to Serialize Dates and Times (NETWORKDAYS)

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