Series - weeks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beemer - 12 Jul 2007 09:37 GMT

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

Reply to this Message

Beemer - 12 Jul 2007 09:40 GMT

| 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
[quoted text clipped - 3 lines]
|
| Beemer

Reply to this Message

Roger Govier - 12 Jul 2007 10:57 GMT

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.

Signature

Regards

Roger Govier

> How in Excel 2007 can I use drag cells to create a weekly date column?
> I
[quoted text clipped - 5 lines]
>
> Beemer

Reply to this Message

Beemer - 12 Jul 2007 14:24 GMT

| Hi
|
[quoted text clipped - 12 lines]
| >
| > Beemer

Roger,

Thanks,

Beemer

Reply to this Message

Brian Withun - 12 Jul 2007 16:14 GMT

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

Reply to this Message

Beemer - 13 Jul 2007 07:10 GMT

| 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
[quoted text clipped - 17 lines]
|
| Brian Herbert Withun

Brian,

Thanks,

Beemer

Reply to this Message