The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel

The following article introduces you to the WORKDAY function - one of the functions in the date and time group function is very popular in Excel.

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel Picture 1

Description: The function returns a date before or after the start date of a specified number of working days. Weekends and public holidays do not count toward business days.

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

Inside:

- start_date: The start date, is a required parameter.

- days: A day not in the weekend and holidays before or after start_date, is a required parameter.

+ days> 0 -> number of days generated in the future.

+ days <0 -> number of days created in the past.

- holidays: Days to be excluded from working days which are not on public holidays.

Attention:

- Excel stores dates as sequential serial numbers to facilitate the calculation process.

- Any one of the arguments is invalid -> the function returns the #VALUE! Error value

- If start_date + days value creates an invalid date -> the function returns the #NUM! Error value

- If days is a decimal, it is truncated to an integer.

For example:

Calculate the days after the working day a specified number of days for the following jobs:

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel Picture 2

- In the cell to calculate, enter the formula: = WORKDAY (F7, G7, H7).

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel Picture 3

- Press Enter -> return value is:

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel Picture 4

- Similarly copying the formula for the remaining value results:

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel Picture 5

- Where the number of holidays is greater than 1 enter the formula: = WORKDAY (F9, G9, H9: H10).

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel Picture 6

- Press Enter -> return value is:

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel Picture 7

Above are instructions and some specific examples when using the WORKDAY function .

Good luck!