Oops! I misread your question


--
Regards,

Peo Sjoblom



"Peo Sjoblom" wrote in message
...
If you put a date in a cell and copy drag down the cell using the right
mouse button you will get an option to fill weekdays only. For dates that
you already have in place you could use a help
column and a formula like

=WEEKDAY(A2,2)5

copy down, select all values including the help column, apply
datafilterauto filter, from drop down in the help column select TRUE.
Then select the visible cells (but NOT the headers) and do editdelete,
select delete entire row. Then remove the filter and the help column


--
Regards,

Peo Sjoblom





"Tom" wrote in message
.. .
I have a column of dates. How can I make it to display only the days of
the week, like Monday, Tuesday, ...... etc.?

TIA
Tom