< Go Back

Series of dates by workdays

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.

WORKDAY Function

The function displays working days falling after a specific date.

Syntax

=WORKDAY(start_day,days,[holidays])

Arguments

  • 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:

=WORKDAY(date,1)

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.

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:

=WORKDAY(B6,1)

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:

=WORKDAY(date,1,holidays)

Note

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.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar