23
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

=WORKDAY.INTL(A1,1,”1111100″)
Let’s consider the below example image.



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 *!! **
23