fx =NETWORKDAYS(A1,B1)ABCProject A2026-01-1573 daysProject B2026-02-2037 daysProject C2025-12-01118 days
📅 Date

NETWORKDAYS Formula for Date

Count business days between two dates. Copy-paste ready for Excel, Google Sheets, and Airtable.

=NETWORKDAYS(A1,B1)
When you need this: When you track delivery timelines and need to count business days (Mon–Fri) between order date (A1) and delivery date (B1).

How it works

  1. 1NETWORKDAYS counts weekdays (Mon–Fri) between two dates.
  2. 2Automatically excludes Saturdays, Sundays, and standard holidays.
  3. 3Return the count of working days (useful for SLAs and turnaround times).

Variations

NETWORKDAYS with custom holidays
=NETWORKDAYS(A1,B1,HolidayRange)
WORKDAY (adds days forward)
=WORKDAY(A1,10)

Related Formulas

TODAY / NOW — Get current date or date/timeDateDATEDIF — Calculate difference between two datesDateEDATE — Add or subtract months from a dateDateYEAR / MONTH / DAY — Extract year, month, or day from a dateDate

Need a formula that's not here?

Generate custom formula →