How to Use the WORKDAY Function in Excel
The WORKDAY function is an essential tool in Excel and Google Sheets for calculating a specific workday before or after a designated date, while automatically excluding weekends and any dates set as holidays.
Basic Syntax
The syntax for the WORKDAY function is as follows:
WORKDAY(start_date, days, [holidays])start_date: The initial date from which the workday count starts.days: The number of workdays to count forward (positive value) or backward (negative value) from the start date.holidays(optional): An array or range of dates that are recognized as holidays and excluded from the workday count.
Examples and Use Cases
Example 1: Calculate Future Workday
Imagine you are managing a project that begins on August 1, 2023, and requires 10 working days to complete. You need to determine the project’s completion date considering weekends and any holidays.
| Start Date | Duration (days) | End Date |
|---|---|---|
| 1-Aug-2023 | 10 | =WORKDAY(A2, B2) |
Example 2: Exclude Holidays
Consider the situation where you need to calculate the date 15 workdays after September 1, 2023. Additionally, holidays falling on September 7, 2023, and September 14, 2023, should be excluded.
| Start Date | Duration (days) | Holidays | End Date |
|---|---|---|---|
| 1-Sep-2023 | 15 | 7-Sep-2023, 14-Sep-2023 | =WORKDAY(A2, B2, C2:C3) |
The above examples demonstrate the utility of the WORKDAY function in Excel and Google Sheets for accurately calculating future or past workdays, while taking holidays and weekends into consideration.
More information: https://support.microsoft.com/en-us/office/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33