Gerry,

In A1 enter 9/1/07 and use the custom format _Week ending dd/mm/yyyy_ to
display the entry.

In A6 enter =A1+7 with the same custom format.

Hope this helps,
Fred

"Gerry Cornell" wrote:

The quarterly spreadsheet has 13 week headers interspersed with detail
for that week thus

COLUMN A

WEEK ENDED 5 JANUARY 2007
Text Detail
Text Detail
Text Detail
Text Detail
Text Detail
Text Detail
WEEK ENDED 12 JANUARY 2007
Text Detail
Text Detail
Text Detail
Text Detail
Text Detail
Text Detail
WEEK ENDED 19 JANUARY 2007
Text Detail
Text Detail
Text Detail
Text Detail
Text Detail
Text Detail

What I would like to be able to do is to change "WEEK ENDED 5 JANUARY
2007" and for the succeeding weeks to be automatically updated. How
might this be easily achieved?

TIA



--

~~~~

Gerry

~~~~~~~~
Enquire, plan and execute.
Stourport, England
~~~~~~~~~~~~~~~~~