Multiple choice technology

Which function will calculate the number of workdays between 6/9/2004 and 8/21/2004?

  1. WORKDAY

  2. DATE

  3. NETWORKDAYS

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

NETWORKDAYS calculates the number of working days (Monday-Friday) between two dates, excluding weekends and optionally specified holidays. For the given range (June 9 to August 21, 2004), it would count only weekdays. The WORKDAY function is different - it adds workdays to a start date to find an end date, not count days between dates.

Keep practicing — related questions