Dates ignoring weekends...

  • Thread starter Thread starter confused man
  • Start date Start date
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
 
Assuming your first date is in cell B1, enter the following formula in B2
and
drag down.
=WORKDAY(B1,1)

--
XL2002
Regards

William

(e-mail address removed)

| 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
|
|
 
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.)
 
Back
Top