WORKDAY Function in Google Sheets

Calculate a workday that is a specific number of days from a start date using the WORKDAY function.

WORKDAY Function

The WORKDAY function in Google Sheets returns a date that is a specific number of workdays away from a given start date.

Syntax

WORKDAY(start_date, num_days, [holidays])
  • start_date: The starting date for the calculation.
  • num_days: The number of workdays to add (can be negative to subtract days).
  • holidays (optional): A range or array of dates to be considered holidays.

Examples

  1. Basic Usage

To find the date 10 workdays from "2024-08-15":

=WORKDAY("2024-08-15", 10)
  1. Including Holidays

To exclude specific holidays listed in range A2:A5:

=WORKDAY("2024-08-15", 10, A2:A5)

Notes

  • Weekends are automatically excluded (Saturday and Sunday).
  • The function can be used for project planning and deadline calculations.
  • NETWORKDAYS: Counts the number of workdays between two dates.
  • EDATE: Returns a date a specified number of months before or after a given date.