Excel Formulas to Create a Series of Dates by Weekends ~ Quick Tips!!

Sometimes, you may need to fill in sequences of weekend dates ( Saturday and Sunday ) only in your worksheet. In Excel, we can drag the date to meet your need but with both weekdays and weekends. Are there any quick ways available for generating a dynamic series of dates that are weekends only in Excel? Let’s dive 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:

You can use the below formula to get the dynamic series of dates with weekends in Excel.

=WORKDAY.INTL(A1,1,”1111100″)

Syntax Explanations:

WORKDAY.INTL – This function helps to calculate the proximate working day based on the values we provide and returns a number that represents the date. Read more on WORKDAY.INTL Function.
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:

Let’s consider the below example image.

Here, we will enter the starting date in Column C.
Now we need to generate the series of dates by weekends 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.

Verdict:

Hope you like this article on how to create a series of dates by weekends in Excel. Let me know if you have any doubts regarding this article or any other excel/VBA topic.

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