Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How Do I Filter Weekend Days In Excel?

Date:2021-11-18 Author:Sandra

I’m always looking forward to weekend days. After all, few people like to work. In our previous tutorial. We can get all dates to show in Excel. So how to show only weekend days in Excel?

Here are all dates in 2022. You can click here to know how to quickly get this table.

How Do I Filter Weekend Days In Excel?

Now we can use the Weekend Function here. Just type = WEEKDAY(A2,2) in cell B2, and press Enter key.

How Do I Filter Weekend Days In Excel?
How Do I Filter Weekend Days In Excel?

When a black cross appears in the lower right corner, double-click it.

How Do I Filter Weekend Days In Excel?

Numbers 6 and 7 represent Saturday and Sunday. Now we filter all the 6 and 7.

How Do I Filter Weekend Days In Excel?

These dates are all Saturdays and Sundays. You can view the calendar to check.

How Do I Filter Weekend Days In Excel?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *