"?B?U3F1aXJlbCBFYXRlcg==?="
wrote

enter 3/6/2005 in A1

B3 enter formula =DAY($A$1)
C3 thru P3 gets =DAY(IF(B3="","",B3+7))

you will get

6
13
20
27
3
10
17
24
31 <this should be May 7 but it is April 31

Actually, it's January 31st (1900)

but wait maybe it is not interpreting B3 as 4/6/2005????

Right.

Try two columns...

3/6/2005 =DAY(A1)
=A1+7 =DAY(A2)
=A2+7 =DAY(A3)
=A3+7 =DAY(A4)
etc


column B will correctly show
6
13
20
27
3
10
17
24
1


--
Marc.