The formula for the work period was great.
How do I get it to not move on to the next two week period automatically?
The formula for the work period was great.
How do I get it to not move on to the next two week period automatically?
I replied to your previous post but you probably didn't
see it.
The formula that I saw changes the two week period every
week, so you'd never be in the second week. The following
formula fixes that. I hope someone has a way to handle the
update problem; I'll be looking for that. I either point
to an entry date for the record instead of using today(),
or paste values at the end of the period.
="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-----
>The formula for the work period was great.
>
>How do I get it to not move on to the next two week
period automatically?
>.
>
How do I, or better yet what date format do I replace TODAY() stih?
"BobT" wrote:
> I replied to your previous post but you probably didn't
> see it.
> The formula that I saw changes the two week period every
> week, so you'd never be in the second week. The following
> formula fixes that. I hope someone has a way to handle the
> update problem; I'll be looking for that. I either point
> to an entry date for the record instead of using today(),
> or paste values at the end of the period.
>
> ="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-----
> >The formula for the work period was great.
> >
> >How do I get it to not move on to the next two week
> period automatically?
> >.
> >
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks