Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
109
Views
Topic starter
I have a list of dates and I need all Sundays to be listed on other cell.
Please advise.
Please find attach file.
Kind regards
Redha
Posted : 15/03/2022 5:55 am
There is no attachment
Posted : 15/03/2022 11:17 am
If you are on Excel for MS365 or 2021, try this:
=FILTER(dates,WEEKDAY(dates,1)=1)
where dates refers to the range containing the list of dates.
Posted : 16/03/2022 2:26 am
Topic starter
Thank you so much brother.
Posted : 16/03/2022 1:30 pm
