The NETWORKDAYS function
Counts the working days (Monday to Friday) between two dates, both included, minus any holidays you list.
Syntax
NETWORKDAYS(start_date, end_date, [holidays])- start_date
- The first date.
- end_date
- The last date.
- holidays (optional)
- Dates to leave out, such as public holidays.
Examples
B1
=NETWORKDAYS(1DATE(2024,3,1),2DATE(2024,3,31))| A | B | |
|---|---|---|
| 1 | 21 |
In plain words: Count the weekdays from 1Mar 1, 2024 to 2Mar 31, 2024.
B1=NETWORKDAYS(DATE(2024,3,25),DATE(2024,3,29),DATE(2024,3,28))
| A | B | |
|---|---|---|
| 1 | 4 |