weekly formula

[winz]

Hi,
Does anyone know of a formula to list weeks?
for example..
A1 Date
A2 3-1-05
A3 10-1-05
A4 17-1-05
etc...

TIA

 

[JulieD]

Hi

easiest way is to type the first date in A2, the second in A3, select them
both and fill down (move cursor over bottom right hand corner of A3 until
you see a +, hold the mouse down & drag as far as necessary).


Cheers
Julie

 

[JulieD]

Hi winz

i'll let you into a secret .. most of the stuff in excel is relatively
simple - once you know how

glad it's solved.

Cheers
JulieD

 

[winz]

Hi

easiest way is to type the first date in A2, the second in A3, select them
both and fill down (move cursor over bottom right hand corner of A3 until
you see a +, hold the mouse down & drag as far as necessary).

Hi,
That was SO simple!
Thank you.

Winz