Need help filtering a date column

[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.

[Ron de Bruin]

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Joe Miller" <[email protected]> wrote in message
news:[email protected]...
>
> 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.
>
>
> --
> Joe Miller
> ------------------------------------------------------------------------
> Joe Miller's Profile: http://www.excelforum.com/member.php...o&userid=29900
> View this thread: http://www.excelforum.com/showthread...hreadid=560811
>

[Ron de Bruin]

EasyFilter have this option also
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Joe Miller" <[email protected]> wrote in message
news:[email protected]...
>
> 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.
>
>
> --
> Joe Miller
> ------------------------------------------------------------------------
> Joe Miller's Profile: http://www.excelforum.com/member.php...o&userid=29900
> View this thread: http://www.excelforum.com/showthread...hreadid=560811
>

[Joe Miller]

Thanks Ron,

Joe Miller