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?
- A. NETWORKDAYS
- B. NETWORKDAYS.INTL (Correct answer)
- C. WORKDAY
- 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