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)

Date Functions: NETWORKDAYS The NETWORKDAYS Function will calculate the number of work days (Monday through Friday) from the Reference Date in Column G to the Date in Column A. 2 Try This: Add a Label We are still on the Date Functions sheet. Select Cell H1. Type the following label: Net Work Days 3. Try This, Too: Use a Date Function Select Cell H2. Go to Formulas->Function Library-> Date & Time. Click on: NETWORKDAYS. Keep going... Formulas->Functtion Library-> Date & Time->NETWORKDAYS