"date" is a defined name range of dates

=IF(ISERR(SMALL(IF(WEEKDAY(date)=6,ROW(INDIRECT("1 :"&ROWS(date)))),ROWS($1:1))),"",INDEX(date,SMALL( IF(WEEKDAY(date)=6,ROW(INDIRECT("1:"&ROWS(date)))) ,ROWS($1:1))))

ctrl+shift+enter, not just enter
copy down


"Old Keith" wrote:

I have a list of dates in the format :
Wednesday,Jul 25,2007
I need to extract from that list all the Fridays.
Is it possible to sort the list into the days of the week ?