Need help filtering a date column

  • Thread starter Thread starter Joe Miller
  • Start date Start date
J

Joe Miller

I have unsucessfully tried to filter weekend dates out of a date column.
I know how to use the WEEKDAY function to identify Saturdays and Sundays
but have not yet figured out how to apply it using the 'Filter'
facility. Help will be much appreciated.
 
Hi Joe

You can use AdvancedFilter with a formula

For Example you dates start in A5 (A4 is the header cell)

Copy this formula in A2 and leave A1 empty
=OR(WEEKDAY(A5,2)={6,7})

Use A1:A2 as your criteria now
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter and selection question 1
date filter in a pivot table 1
Highlighting weekends in a calendar 2
filtering dates in a Pivot Table Report Filter 3
Advanced filter 7
Weekdays between two dates in Excel? 1
Excel Macro for deleting Rows containing dates greater than "today" 0
Create a shorter list of dates 11

Back
Top