Autofill Dates Through Worksheets?

[Contramotion]

Hi All,
I'm new to this forum, so sorry if this is a daft question..
Is it possible to autofill dates through worksheets, so that the first
date of each week shows in the same cell reference through a workbook?
(eg sheet 1 has 1st April in cell c1, sheet 2 has 8th April in cell c1,
sheet 3 has 15th April in cell c1...etc). I was hoping I'd be able to
select all the tabs throughout a 52-sheet workbook and autofill the
dates, but I can't. If autofill isn't an option, is there another way
to achieve the same result without typing the first date of each week
on every sheet?
Thanks in advance to anyone who can help with this.
Cheers!!

 

[Bob Umlas]

How about a macro?
Sub Fill52()
On Error Resume Next
MyDate = #4/1/03#
for i=1 to 52
Sheets(i).range("C1").value=MyDate
MyDate = MyDate + 7
Next
End Sub

Bob Umlas
Excel MVP

 

[Contramotion]

Bob, that's brilliant. Thanks SO MUCH. I don't do VBA (really must learn
some!) and I was trying to get a macro working using the recorder, but
with no success.
You're a star!