| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help filtering a date column
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help filtering a date column
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help filtering a date column
EasyFilter have this option also
http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Joe Miller" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help filtering a date column
Thanks Ron, Joe Miller -- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How do I retrieve a date in a column of dates which > my criteria | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Hybrid Mode
