WORKDAY

The WORKDAY function in Google Sheets calculates the end date after a specified number of working days. It is useful for determining deadlines or project timelines that exclude weekends and holidays.

Function Syntax and Parameters

Syntax: WORKDAY(start_date, num_days, [holidays])

Parameters:

• start_date: The starting date from which to calculate the working days.
• num_days: The number of working days to advance from the start date.
• holidays: [Optional] A range or array of dates that are considered holidays and should be excluded from the calculation.

Step-by-Step Tutorial

1. Using WORKDAY with a specified number of working days:

   • Example: =WORKDAY(A1, 5)
   • Result: Returns the date that is 5 working days after the date in cell A1.

2. Using WORKDAY with a list of holidays:

   • Example: =WORKDAY(A1, 10, B1:B5)
   • Result: Returns the date that is 10 working days after the date in cell A1, excluding the dates listed in cells B1 to B5.

Use Cases and Scenarios

1. Project Management: Calculate project deadlines based on working days.
2. Employee Leave: Determine the return date after a specified number of working days.
3. Delivery Schedule: Calculate the expected delivery date based on working days.

Related Functions

• NETWORKDAYS: Calculate the number of working days between two dates.
• EDATE: Add or subtract a specified number of months to a date.

Related Articles

• Working with Dates in Google Sheets: A Comprehensive Guide
• How to Use the WORKDAY Function in Google Sheets