You could enter the following formula in a helper cell:

=WEEKDAY(A2,2)

and copy down, assuming your dates start in cell A2. Then apply
autofilters, and filter the helper column using Custom... Is Greater
Than ... 5

This will display only the rows which correspond to weekends, so you
could highlight the rows displayed and Edit | Delete Row. Then select
All on the filter applied to the helper column, and you will be left
with only weekday data.

Hope this helps.

Pete

Arne Hegefors wrote:

Hi! I have a list of dates (several years) with corresponding prices for
every date. I want to have only weekdays. Thus I need to single out the
weekdays´. How can I do this in a simple manner?