how to formula the filter for day of the week

[aaaaa34]

Hey guys,

I hope life is going on oke for u.
i need ur help as a rookie of excel.

In example file i wrote different dates along the column. How i can i write a filter in Table for showing only Thursdays from those dates?
File: http://s3.dosya.tc/server18/w1VSFP/thursdays.xlsx.html

thanks a lot for ur help my friends. Take care.

[daffodil11]

You could use a Helper Column. B2:

=WEEKDAY([@DATE])=5

Filter B = True

[aaaaa34]

pls make it in the file my friend
i dont know how to apply it.

can u apply and attach it pls?

[daffodil11]

It should be as simple as typing =WEEKDAY([@DATE])=5 into B2 and hitting enter.

thursdays(1).xlsx

[aaaaa34]

thanks for ur response
but why we dont have a better B column?
i mean that i wanna see all day names of each date and When i tick in filter Thursday, only Thursday dates ll appear in A column
or When i tick Monday B coumn filter, i ll see only friday dates alone the A column.

as summary, i wanna tick different days of the week in B column and see them in A column.

[daffodil11]

Ohhhhh.

Like this.

thursdays(1).xlsx

[aaaaa34]

waaaaaaaaaay u re great MY FRIEND!!!
THANKS A LOT!!! thank u so much!!!
take care urself, have a nice evening

[daffodil11]

No problem, glad I was able to help out.