Loading…
Loading…
WEEKDAY turns a date into a day number. By default Sunday = 1 … Saturday = 7; with a second argument of 2, Monday = 1 … Sunday = 7, which makes "is it a weekend?" a simple >5 test. NETWORKDAYS counts the working days (Mon–Fri) between two dates including both ends, and skips any holidays you list.
Syntax
WEEKDAY(date, [return_type]) · NETWORKDAYS(start, end, [holidays])
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.