Thanks Bob that worked great.

Is there any way of stopping the dates from changing to the next period once
the document has been created and we move into the next period?

"Bob Phillips" wrote:

="Work Period "&TEXT(TODAY()-WEEKDAY(TODAY(),1),"mmmm
d")&" -"&TEXT(TODAY()-WEEKDAY(TODAY(),1)+14,"mmmm d, yyyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JLyons" wrote in message
...
I am trying to get this formula to start the work period on a saturday and
end on a friday (rather than the normal week of Sunday thru Saturday)

="Work Period "&TEXT(TODAY()-WEEKDAY(TODAY(),1)+1,"mmmm d")&" -
"&TEXT(TODAY()-WEEKDAY(TODAY(),1)+14,"mmmm d, yyyy")

As is it starts on Sunday and ends on saturday. I tried changing the +1 to
a
-1, but that didn't work.
What do I need to change to make this happen?