Clear list from weekends
 

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?

Clear list from weekends
 

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?

Clear list from weekends
 

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?

Clear list from weekends
 

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?

Clear list from weekends
 

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?