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?

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

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.


-----Original Message-----
="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?


.

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?