Computer Knowledge · University of Kashmir Junior Accounts Assistant (2026) — Set A · Last updated:

View the full solved paper: University of Kashmir Junior Accounts Assistant (2026) — Set A

Which Excel function calculates the number of working days between two dates, explicitly allowing the user to customize which days of the week are designated as weekends?

  1. A. NETWORKDAYS
  2. B. NETWORKDAYS.INTL (Correct answer)
  3. C. WORKDAY
  4. D. DAYS360

Correct Answer

Option B — NETWORKDAYS.INTL

Detailed Solution & Explanation

While NETWORKDAYS hardcodes Saturday and Sunday as the weekend, NETWORKDAYS.INTL accepts an optional weekend argument (either a numeric code or a 7-character binary string of 0s and 1s) allowing the user to customise which days are weekends (Option B). Therefore, Option B (NETWORKDAYS.INTL) is the verified correct response under MS Excel (Computer Knowledge).

Topics covered: MS Excel MS Office