Dates ignoring weekends...

C

confused man

Hello all,

I'm working on sumarizing daily data about stocks in my portfolio. Daily
price flucuations etc. I type in dates as 1/1/2004 for example. and I want
to click an drag all the way the the length of one year. Is there a way to
tell excel to do this but ignore weekend dates? so for example using this
week 7/19/2004 -- 7/23/2004, but then have it skip saturday and sunday and
pick right back up with 7/26/2004?

Thanks so much,
Confused Man
 
W

William

Assuming your first date is in cell B1, enter the following formula in B2
and
drag down.
=WORKDAY(B1,1)

--
XL2002
Regards

William

[email protected]

| Hello all,
|
| I'm working on sumarizing daily data about stocks in my portfolio. Daily
| price flucuations etc. I type in dates as 1/1/2004 for example. and I want
| to click an drag all the way the the length of one year. Is there a way to
| tell excel to do this but ignore weekend dates? so for example using this
| week 7/19/2004 -- 7/23/2004, but then have it skip saturday and sunday and
| pick right back up with 7/26/2004?
|
| Thanks so much,
| Confused Man
|
|
 
D

Dave Peterson

Another way is to rightclick and drag the fill handle.

When you let go, you'll see an option to fill weekdays. (Even if you're done,
it might be worth trying just to see the options.)
 
Top