If you want to generate a series of only working days, which is Monday to Friday in a month falling after a particular date, then you can do this task very easily in Excel by using a simple formula which uses the WORKDAY function.
The function displays working days falling after a specific date.
- Start_date – The beginning date
- Days – The working days after or before the beginning date.
- Holidays – The non-working dates.
In this case, we’ll use the formula as shown:
Excel uses the WORKDAY function with the above-given formula and returns the next working day.
Let us understand it with the help of an example.
Figure 1: Illustration of WORKDAYS function
In the example given above, we provide a hard code date in B6. This is the starting date and to get the working days, we use the formula in the cell B7 as shown:
This formula returns next working day i.e. 15/10/18 as the result since 13th and 14th are Saturday and Sunday.
If you need any other holiday to be considered, then you can add the optional argument of the holiday along with the formula in the WORKDAY function:
We can also use WORKDAY.INTL function for the same. When we are working with the custom weekends which are actually the working days, then we need to use the WORKDAY.INTL function. This will allow you to set the days to weekends by putting the weekend argument in a numeric code.