unlock

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

0:00
↔️ ↕️

Timecodes:

hello and welcome to this excel tips

video i am sumit bansal and in this

video i am going to show you a really

clever formula to extract the weekend

dates for any given month so here i have

the year value and i have the month

value and i have used a formula so that

it gives me all the weekend dates for

february so 5th february 2022 is a

saturday and 6th february is a sunday

now if i come here and i change the

month number then this list is going to

automatically update so now it gives me

the weekend dates in january or if i

come here and i enter three for march

then it is going to give me all the

weekend dates in march so let's see how

to do this

let me first show you a formula that can

be used in microsoft 365 and then later

i'm also going to show you the formula


Related queries:


how to open excel xlsx file
how to open excel file using xlsxwriter
how to unlock excel file
how to unlock an excel spreadsheet
how do i unlock my excel file
how to unlock excel