Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'm still stuck
I asked another question about Bob T's reply
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |