Starting work period on a Saturday and ending on a friday

[Guest]

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?

 

[Bob Phillips]

="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)

 

[BobT]

The previous shows a 2 week work period that changes every
week.

Try this
="Work Period "&TEXT(TODAY()-MOD(TODAY(),14)+7*IF(MOD(TODAY
(),14)<7,-1,1),"mmmm d")&" - "&TEXT(TODAY()-MOD(TODAY(),14)
+7*IF(MOD(TODAY(),14)<7,-1,1)+13,"mmmm d, yyyy")

This one is based on the 1/1/1900 date system.
If you don't like that, you can also use Iseven or Isodd
functions to determine what week your new work period
begins, but is an even longer function.

 

[Guest]

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?