Ravindra BagaleCourses & study guides मराठी Track your progress

3. Formulas and Functions

3.11 Working Days, DATEDIF and WEEKDAY

By Last updated:

NETWORKDAYS, WORKDAY and WEEKDAY with example — in 30 seconds

What: NETWORKDAYS counts Monday-to-Friday days between two dates. WORKDAY finds the date after N working days. WEEKDAY gives the day number.

Why: Vendor payment terms, SLA deadlines and weekend tags all depend on working days, not calendar days.

Tiny example: From 02-11-2026 to 30-11-2026 there are 21 working days. 10 working days after 02-11-2026 is 16-11-2026.

First look at the data (before → after):

NETWORKDAYS, WORKDAY and WEEKDAY with example: before and after tables, fictional FreshGo Maharashtra data

Expected result — Answers (no holiday list)

Formula Answer
=NETWORKDAYS(DATE(2026,11,2),DATE(2026,11,30)) 21
=WORKDAY(DATE(2026,11,2),10) 16-11-2026
=WEEKDAY(DATE(2026,11,8),2) 7 (Sunday)

About this data: Teaching sample for a fictional shop “CityBasket Retail”. Figures and names (e.g. Priya Deshmukh) are made up for this lesson on working days datedif and weekday.

Before table and formula as text

Before — Inputs

Cell Value
Start date 02-11-2026
End date 30-11-2026
Order date to tag 08-11-2026

About this data: Demo table only — not real customer or company data. Built to practise working days datedif and weekday.

Formula / click path

=NETWORKDAYS(DATE(2026,11,2),DATE(2026,11,30))
=WORKDAY(DATE(2026,11,2),10)
=WEEKDAY(DATE(2026,11,8),2)   (Mon=1 … Sun=7)

Do it step by step:

  1. Type =NETWORKDAYS(DATE(2026,11,2),DATE(2026,11,30)) and press Enter.
  2. Type =WORKDAY(DATE(2026,11,2),10) and format the cell as a date.
  3. Type =WEEKDAY(DATE(2026,11,8),2). With type 2, Monday is 1 and Sunday is 7.
  4. To skip holidays, put the holiday dates in a range and add it as the third argument.
  5. Check: 21, 16-11-2026 and 7.
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)

About this data: Made-up rows so you can copy the pattern for working days datedif and weekday. Currencies may use ₹, £, € or $.

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.

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.

Loading practice tasks...

  1. Working days in November (Easy): Count working days (Mon to Fri) from B2 to B3.
  2. Project: working days (Easy): Count working days from Project!B2 to Project!B3.
  3. Working days without the holiday (Medium): Count working days from B2 to B3, leaving out the holiday in B5.
  4. 10 working days later (Medium): Find the date 10 working days after B2.
  5. Day of the week (Medium): Find the weekday number of B4 (Monday = 1).
  6. Project: minus the holiday (Medium): Count working days from Project!B2 to Project!B3, leaving out Project!B4.
  7. Project: 5 working days later (Medium): Find the date 5 working days after Project!B2.
  8. Project: holiday weekday (Medium): Find the weekday number of Project!B4 (Monday = 1).
  9. Days between dates (Hard): Count the days from B2 to B3 with DATEDIF.
  10. Project: contract months (Hard): Count full months from Project!B5 to Project!B3.

See all practice tasks in the Task Hub →

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Working Days Datedif And Weekday?
Card 1: What is Working Days Datedif And Weekday? · Download PNG
Revision card 2: Tiny example — Working Days Datedif And Weekday
Card 2: Tiny example — Working Days Datedif And Weekday · Download PNG
Revision card 3: Checklist — Working Days Datedif And Weekday
Card 3: Checklist — Working Days Datedif And Weekday · Download PNG