Excel Tutorial – WORKDAY

The WORKDAY function in Microsoft Excel is a built-in function that allows you to calculate the date that is a certain number of working days before or after a given start date. It takes two arguments: the start date and the number of working days to add or subtract from the start date. The function returns the resulting date as a serial number that can be formatted as a date.

To use the WORKDAY function in Excel, follow these steps:

1. Open a new or existing worksheet in Excel.
2. Select the cell where you want to display the result of the WORKDAY function.
3. Type the following formula in the cell: =WORKDAY(start_date, days, [holidays])
4. Replace “start_date” with the cell reference or the start date, “days” with the number of working days to add or subtract from the start date, and “[holidays]” with the optional list of holidays that should be excluded from the calculation.

The “[holidays]” argument is optional, and can be a range of cells that contain the dates of the holidays that should be excluded from the calculation, or an array of holiday dates. If you omit the “[holidays]” argument, the function will assume that there are no holidays and include all days in the calculation.

5. Press Enter to calculate the result of the WORKDAY function.

For example, let’s say you have a list of start dates in column A, and you want to calculate the date that is 5 working days after each start date and display the result in column B. You can use the WORKDAY function as follows:

1. In cell B1, type the formula =WORKDAY(A1, 5)
2. Press Enter to calculate the result.
3. Select cell B1, and then drag the fill handle (the small square in the bottom-right corner of the cell) down to fill the formula in the remaining cells of column B.

This will calculate the date that is 5 working days after each start date in column A and display the result in column B.

Note: The WORKDAY function returns the resulting date as a serial number, which can be formatted as a date using the DATEVALUE function or the Format Cells dialog. For example, you can use the formula =DATEVALUE(WORKDAY(A1, 5)) to convert the serial number to a date, or you can select the cell and use the Format Cells dialog to format the cell as a date.