is there a formula for "Week of August 4-8'
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!
|