Yes, you're right.

Apologies.

Dave
--
Brevity is the soul of wit.


"Sandy Mann" wrote:

Note that WEEKDAY is part of the analysis toolpak, and not a regular
function. Add it via the Tools--Add Ins option.

I think that you are thinking about the WORKDAY() function Dave.

another option:

=IF(WEEKDAY(A1,2)<6,"","Weekend")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Dave F" wrote in message
...
One possible way: create a helper column which runs the following formula
(assuming dates start in A1):
=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"WEEKEND","")

Delete any row where "WEEKEND" appears in the helper column.

Note that WEEKDAY is part of the analysis toolpak, and not a regular
function. Add it via the Tools--Add Ins option.

Dave
--
Brevity is the soul of wit.


"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?