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
In WEEKDAY, if you don't give return_type, Sunday = 1 – many students assume Monday = 1 and get the weekend wrong. Always write WEEKDAY(date,2); then >5 means weekend. Keep the list of holidays in a separate range and give it to NETWORKDAYS.
Ravindra Bagale's Tip – मराठी
WEEKDAY मध्ये return_type न दिल्यास Sunday = 1 असतो – बरेच students Monday = 1 समजतात आणि weekend चुकीचा येतो. नेहमी WEEKDAY(date,2) लिहा, मग >5 म्हणजे weekend. Holidays ची list वेगळ्या range मध्ये ठेवा आणि NETWORKDAYS ला द्या.
Ravindra Bagale's Tip – हिंदी
WEEKDAY में return_type न दो तो Sunday = 1 होता है – बहुत से students Monday = 1 मान लेते हैं और weekend गलत आता है. हमेशा WEEKDAY(date,2) लिखो, फिर >5 का मतलब weekend. Holidays की list अलग range में रखो और NETWORKDAYS को दो.
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.