sort by day of the week?

[Authentik]

Excel 2002

I have 10 years of grain prices...one price for each trading day of th
year. In 'A' we have the date, in 'B' the price. What I need to do i
get a list of prices for Mondays, Tuesdays, Wednesdays, etc...

Possible? (I really, really don't want to do this manually)

Than

 

[duane]

add a column = weekday(a1,1) etc and do a sort on this colum

 

[Authentik]

Thank you. You saved me 3 or 4 hours of excruciating data entry. Thi
was the last step of a vital report. Now I can do my charting and g
home

 

[duane]

no problem....if the dates are really dates (and not text) you could
also format that column as custom.....ddddd and see the day names