Series - weeks

[Beemer]

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]

| 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 Govier]

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.

 

[Beemer]

| 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
|
|
| | > 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 Withun]

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]

| 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