3.11 Working Days, DATEDIF and WEEKDAY
| Function | Syntax | Example | Result |
|---|---|---|---|
| NETWORKDAYS | NETWORKDAYS(start, end, [holidays]) |
=NETWORKDAYS(DATE(2026,11,2),DATE(2026,11,30)) |
21 |
| NETWORKDAYS with holidays | holidays in M2:M3 = 09-11-2026, 10-11-2026 |
=NETWORKDAYS(DATE(2026,11,2),DATE(2026,11,30),M2:M3) |
19 |
| WORKDAY | WORKDAY(start, days, [holidays]) |
=WORKDAY(DATE(2026,11,2),10) |
16-11-2026 |
| WORKDAY with holidays | =WORKDAY(DATE(2026,11,2),10,M2:M3) |
18-11-2026 | |
| NETWORKDAYS.INTL / WORKDAY.INTL | weekend code, e.g. 11 = Sunday only | =NETWORKDAYS.INTL(start,end,11) |
6-day week |
| DATEDIF | DATEDIF(start, end, unit), unit "Y", "M", "D", "YM", "MD", "YD" |
=DATEDIF(DATE(2024,6,15),DATE(2026,11,2),"Y") |
2 |
| WEEKDAY | WEEKDAY(date, [return_type]); type 2: Mon = 1 … Sun = 7 |
=WEEKDAY(B11,2) (08-11-2026) |
7 (Sunday) |
The holidays M2:M3 are a fictional office holiday list for Diwali week. DATEDIF does not appear in the function list (type it fully); Microsoft documents that the "MD" unit can give wrong results, so avoid it.
Worked example – vendor tenure. Kolhapur supplier onboarded 15-06-2024; on 02-11-2026: =DATEDIF(A2,B2,"Y")&" years "&DATEDIF(A2,B2,"YM")&" months" → 2 years 4 months.
Ravindra Bagale's Tip
WEEKDAY madhe return_type na dilyas Sunday = 1 asto – khup students Monday = 1 samajtat aani weekend chukicha yeto. Nehmi WEEKDAY(date,2) liha, mag >5 mhanje weekend. Holidays chi list vegli range madhe theva aani NETWORKDAYS la dya.
Practice task
Mark each order as Weekday/Weekend. Count working days in December 2026 excluding 25-12-2026. Find the delivery due date 3 working days after each order date.