Learn How to Use Microsoft Excel WORKDAY Function

Microsoft Excel WORKDAY Function

The WORKDAY function's primary purpose is to get the days and working days in the past and future. With the help of the Microsoft Excel WORKDAY function, you can take dates and return the nearest working day in the near future and past, based on the offset value you have provided. The WORKDAY function can be used to calculate the delivery dates, completion dates, ship dates, etc., that need to be taken into account of working and non-working days.

WORKDAY Function Return Value

The return value will be a serial number representing a specific date as per Excel.

WORKDAY Function Syntax

= WORKDAY(start-date, days, [holidays])

Where the arguments:

• start-date: The date from where you start.
• days: It represents working days before or after the start-date.
• holidays: It represents a list of dates, which is considered as non-working days (optional).

How to Use Microsoft Excel WORKDAY Function?

As we know, the WORKDAY function extracts the date, which represents the nearest working day and N days in the past or future. The WORKDAY can be used to calculate the delivery dates and other due dates, excluding the non-working days. You can use the positive number to calculate the future date and the negative number to calculate the past date.

By default, the WORKDAY function will exclude Saturday and Sunday. In case you want to customize which days of the week should be considered as the weekend days, you can use WORKDAY.INTL function.

Check out the list of all other articles:

• Learn How to Use Microsoft Excel WEEKNUM Function
• Learn How to Use Microsoft Excel SECOND Function
• Learn How to Use Microsoft Excel NOT Function
• Learn How to Use Microsoft Excel AND Function