Becky

You will need to enter the first date somewhere, I used F1.
The header for the first sheet is the formula:

="Week of "&TEXT(F1,"mmmm dd")&TEXT(F1+4,"-dd")

On sheet2 F1 enter =Sheet1!F1+7 to get the next Mondays date.
On sheet3 the formula in =Sheet2!F1+7

And just copy the Header accross all sheets.

Regards
Peter Atherton
"Teacher_Becky" wrote:

Ooops - Using 2007.

"Teacher_Becky" wrote:

I am creating a teacher lesson plan book. I've been able to do some automatic
filling and other simple formulas for workday dates. However, I can't think
of a way, short of typing each character, to have the phrase "Week of..."
generate dates, and only workday dates - no Saturday/Sunday. So, the heading
on each page would be 'Week of August 4-8', next would be 'August 11-15', and
so on through to June of next year. I only know a couple formulas, and would
like to get better at trying to consider more possibilities by myself. So any
help or insight would be appreciated.

Ideally I would like to be able to use this same file next year and change
the 1st date and have all the others change.

Thanks!