Series - weeks

How in Excel 2007 can I use drag cells to create a weekly date column? I
can make a number series and a days series but if I enter two Thursdays as
consecutive weeks there is no drag handle visible.

rgds,

Beemer

Beemer
Thu Jul 12 03:40:55 CDT 2007


"Beemer" <Beemer@nowhere.com> wrote in message
news:OVMZu$FxHHA.276@TK2MSFTNGP06.phx.gbl...
| How in Excel 2007 can I use drag cells to create a weekly date column? I
| can make a number series and a days series but if I enter two Thursdays as
| consecutive weeks there is no drag handle visible.
|
| rgds,
|
| Beemer
|
|
|

Roger
Thu Jul 12 04:57:41 CDT 2007

Hi

I get no problem with XL2007.
If I enter 12/07/2007 in A1 and 19/07/2007 in A2, mark both cells the
hover over the bottom right corner of A2, the fill handle is there.
Dragging down fills in 26/07, 2/08 etc.

--
Regards

Roger Govier


"Beemer" <Beemer@nowhere.com> wrote in message
news:OVMZu$FxHHA.276@TK2MSFTNGP06.phx.gbl...
> How in Excel 2007 can I use drag cells to create a weekly date column?
> I
> can make a number series and a days series but if I enter two
> Thursdays as
> consecutive weeks there is no drag handle visible.
>
> rgds,
>
> Beemer
>
>

Beemer
Thu Jul 12 08:24:15 CDT 2007


"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:%23dGROsGxHHA.600@TK2MSFTNGP05.phx.gbl...
| Hi
|
| I get no problem with XL2007.
| If I enter 12/07/2007 in A1 and 19/07/2007 in A2, mark both cells the
| hover over the bottom right corner of A2, the fill handle is there.
| Dragging down fills in 26/07, 2/08 etc.
|
| --
| Regards
|
| Roger Govier
|
|
| "Beemer" <Beemer@nowhere.com> wrote in message
| news:OVMZu$FxHHA.276@TK2MSFTNGP06.phx.gbl...
| > How in Excel 2007 can I use drag cells to create a weekly date column?
| > I
| > can make a number series and a days series but if I enter two
| > Thursdays as
| > consecutive weeks there is no drag handle visible.
| >
| > rgds,
| >
| > Beemer
| >
| >
Roger,

Thanks,

Beemer

Brian
Thu Jul 12 10:14:10 CDT 2007

You can also use the formula =OFFSET(A2,-1,0)+7 in cell A2, and as
long as its formatted as a date it will display 7 days beyond the date
shown above it.

These formulas
A1 = Jan 1, 2008
A2 = OFFSET(A2,-1,0)+7
A3 = OFFSET(A3,-1,0)+7
A4 = OFFSET(A4,-1,0)+7

Will show these values:
A1 = Jan 1, 2008
A2 = Jan 8, 2008
A3 = Jan 15, 2008
A4 = Jan 22, 2008

You can copy/cut/paste these cells anywhere within Column A and
they'll keep working. Using the OFFSET function assures that each
cell calculates itself based on the cell immediately above itself.

Brian Herbert Withun

Beemer
Fri Jul 13 01:10:28 CDT 2007


"Brian Withun" <bhwithun@gmail.com> wrote in message
news:1184253250.136120.216690@n60g2000hse.googlegroups.com...
| You can also use the formula =OFFSET(A2,-1,0)+7 in cell A2, and as
| long as its formatted as a date it will display 7 days beyond the date
| shown above it.
|
| These formulas
| A1 = Jan 1, 2008
| A2 = OFFSET(A2,-1,0)+7
| A3 = OFFSET(A3,-1,0)+7
| A4 = OFFSET(A4,-1,0)+7
|
| Will show these values:
| A1 = Jan 1, 2008
| A2 = Jan 8, 2008
| A3 = Jan 15, 2008
| A4 = Jan 22, 2008
|
| You can copy/cut/paste these cells anywhere within Column A and
| they'll keep working. Using the OFFSET function assures that each
| cell calculates itself based on the cell immediately above itself.
|
| Brian Herbert Withun
|
|
Brian,

Thanks,

Beemer