Excel Formulas to Generate Series of Dates by Workdays ~ Easily!!

In the previous post, we have learned how to create a series of dates by weekends in Excel. Suppose you may need to generate the series of dates by workdays only (Monday to Friday) in Excel. How could you calculate them quickly? This article will show you some methods to achieve it. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to get the dynamic series of dates with workdays in Excel, you can use the below formula.

=WORKDAY(A1,1,holidays)

Syntax Explanations:

WORKDAY – In Excel, the WORKDAY Function helps to calculate the proximate working day based on the value we provide and returns a number that represents the date.
A1 – It represents the input date from your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

First, we will enter the starting date in Column C.
Now we need to generate the series of dates by working days starts from the given date.

So, apply the above-given formula and press the ENTER key.

Finally, you will get the result as shown below.

Bottom-Line:

In this way, we learned how to create a series of dates by workdays in Excel. If you encounter any issues , you may tell us in the comments below. Also, share your experiences with this article.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **