How do I create a weekly series?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the fill series fill handle, there is monthly or yearly, but not weekly or
bi-weekly.
How can i set it up to enter a date series by week?
 
Depends on what version you're using.

Drag down date with right button, and when released, there might be a
*bottom* choice of "series", *not* the "fill series" choice.

This gives you an option to click on "days", and then pick a "step value",
where you can enter 7 for weekly, or 14 for bi-weekly.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

In the fill series fill handle, there is monthly or yearly, but not weekly
or
bi-weekly.
How can i set it up to enter a date series by week?
 
Sorry! Should have said Office 2003.
If I understand your answer it seems that I have to manually do it every
time. Seems strange that they would have left out weekly in the auto
grouping.
 
Hi RagDyeR,

What version gives the option to click on "days", and then pick a "step
value"?
I tried Xl2000 and Xl2003 and they didn't.

Regards,
Stefi


„RagDyeR†ezt írta:
 
XL2K *does* have that option, so would XL03 also.
I was referring to *old* versions, not the new ones.

Try it again:

Select cell containing date,
*Right* click and drag on the "fill handle".
Release mouse.
Click on choice at the *BOTTOM* of the pop-up that says "Series",

*NOT* the choice at the top that says "Fill Series".
 
OK. That works. I suppose for bi-weekly, I would enter a step value of 14.
Still seems strange that it wouldn't be built in, though.
 
Back
Top