These functions are useful for working-day calculations.

NETWORKDAYS

Purpose

Counts working days between two dates, excluding weekends.

Syntax

=NETWORKDAYS(start_date,end_date,[holidays])

Example

Start Date

End Date

Working Days

01-Sep-2026

30-Sep-2026

  

Formula:

=NETWORKDAYS(A2,B2)

NETWORKDAYS with Holidays

Suppose holidays are listed in:

H2:H4

Formula:

=NETWORKDAYS(A2,B2,H2:H4)

Excel excludes weekends and the listed holidays.

WORKDAY

Purpose

Returns a date after a specified number of working days.

Syntax

=WORKDAY(start_date,days,[holidays])

Example

Start Date: 28-Sep-2026
Working Days: 10

=WORKDAY(A2,B2)

Excel returns the date after 10 working days, excluding weekends.

Real-World Uses

  • Project deadlines
  • Delivery dates
  • Employee joining dates
  • Task completion dates
  • Business working-day calculations

Practice

Create a project deadline calculator using NETWORKDAYS and WORKDAY.

PreviousNext