Learn How to Use Microsoft Excel WORKDAY Function
In this article, you will learn how to use the Microsoft Excel WORKDAY function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel WORKDAY function return value and syntax with the help of some examples.
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: