Extract Weekend Dates for Any Month in Excel (Clever Formula)

In this video, I will show you a clever formula to extract the weekend dates for any selected month/year.

I am going to show you the formula to use in Excel for Microsoft 365, as well as a formula that will work in all the versions of Excel.

00:00 Intro
00:36 Get Weekend Dates for Any Month (Excel 2021 and Microsoft 365)
07:40 Get Weekend Dates for Any Month (All Excel Versions)

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.

Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[jonminer]

Hi, Sumit. I enjoy your expertise in Exel. I will use some of your formulas in my work. Thanks for sharing! Stay Healthy!

[IvanCortinas_ES]

Brilliant resolution. Excellent tutorial, as always. Thanks a lot.

[vreadyall]

I have searched in YouTube in this regard few days back, but I didn't get right video. Tq for sharing this video.

[sekharispassion]

Thank you for the formula for non O365 users.

[damariceakinyi]

It's taken me some time to play around with the formula and understand the rationale for the [row()-4] part, but I've finally found a way around it. Thanks for the great tutorial!

[KeyserTheRedBeard]

magnificent upload TrumpExcel. I crushed the thumbs up on your video. Keep on up the first-rate work.

[williamarthur]

Really useful and well explained, never knew about the code string for working non working.

[gilgurevich]

I learned so many new things from such a simple secenrio - Wonferful!

[星空-ik]

Thank you, thank you!!! This was what I was looking for.

[nadermounir]

Amazing Video 📹 Trump. Thank you for your hard work 👍

[kuldeep.]

Wow great ❤❤❤😍😍❤❤❤🤗🤗🤗🤗🙏🙏🙏🙏🙏🙏thank you so much😊

[mrbeatleg]

I've been looking for this for a long time, thanks!!

[payaljain]

Hi Sumit, Kindly make videos on excel combined formulas as well.

[npc]

Absolutely incredible. This is exactly what I needed :D

[ajayveduru]

Thank you very much bro
❤️
I want to know about how to make sheet 13 in excel

[jerrydellasala]

This formula is slightly longer than the one you used, but illustrates the power of MS 365 Array Formulas more clearly:
=FILTER( SEQUENCE( EOMONTH( DATE(B1, B2, 1), 0 ) - DATE(B1, B2, 1)+1, , DATE(B1, B2, 1)), WEEKDAY(SEQUENCE(EOMONTH(DATE(B1, B2, 1), 0) -DATE(B1, B2, 1)+1, , DATE(B1, B2, 1)), 2)>5)
Although longer, I think it's clearer in what it's doing - Filtering an array of dates for a month by returning only Saturday and Sunday using the WEEKDAY function with option 2 to return Saturday as 6 and Sunday as 7. I only point this out because the only difference between the MS 365 formula and the Earlier Version formula is that the new formula spills rather than having to lock the values of the Month and Year and copying the formula down. Another tip (from Chandoo), use Conditional Formatting - Format only cells that contain - No Blanks, to add a border to cells with values rather than formatting the maximum range.

[PranavManiar]

Hi, thanks for the info. It helped me get work done. But I was not able to do the same in other PC with MS Excel 2007. How to use it in Excel 2007? Function "workday.intl" is not working there.

[wayneedmondson]

Hi Sumit. Great trick! I've got a version of my own, but YT keeps deleting the comment when I post it :((
Thanks always for your great and clever solutions. Thumbs up!!

[AMITJAIN-votm]

Hi sumit ihave a query related sum function in gradesheet, how can you help me for the same.tanx