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.
Download Example File used in the video:
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)
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Brilliant resolution. Excellent tutorial, as always. Thanks a lot.
I have searched in YouTube in this regard few days back, but I didn't get right video. Tq for sharing this video.
I've been looking for this for a long time, thanks!!
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.
Thank you very much bro
❤️
I want to know about how to make sheet 13 in excel
Please i ask about current account statement by excel 2016 pleas
Wow really great work thanks
Great! thanks
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:
✅ Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
✅ Free VBA course – https://bit.ly/excel-vba-course
✅ Free Power Query Course – https://bit.ly/power-query-course
Thank you for the formula for non O365 users.