weekly formula

  • Thread starter Thread starter winz
  • Start date Start date
W

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
 
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
 
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
 
JulieD said:
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).
Click to expand...

Hi,
That was SO simple!
Thank you.

Winz
 
Back
Top