+ Reply to Thread
Results 1 to 2 of 2

stop a countdown counting when date reached?

Hybrid View

  1. #1
    Registered User
    Join Date
    09-21-2015
    Location
    Chorley, England
    MS-Off Ver
    Microsoft 2010
    Posts
    1

    stop a countdown counting when date reached?

    Hi

    O3 = date added to list
    P3 = waiting (yes/no)
    Q3 = weeks waiting - has a formula that counts weeks waiting: =IF(O3="","",INT(((TODAY()-O3)/7)))
    R3 = breach date - =IF(O3="","",INT((O3+42)))
    S3 = date booked

    Basically is there a formula/alter current formula so that the weeks waiting will automatically stop counting when the date booked date is reached?

    Thanks

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,301

    Re: stop a countdown counting when date reached?

    Formula: copy to clipboard
    =if(o3="","",if(today()>=s3,"",int(((today()-o3)/7))))


    I don't know why this is all in lower case - the formula was copied directly...
    Last edited by Bernie Deitrick; 09-21-2015 at 11:28 AM.
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stop a date countdown when I already have a formula
    By KBIO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2014, 06:27 PM
  2. Stop when a value is reached
    By tommycasper in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-06-2014, 10:05 AM
  3. Stop countdown
    By rajtck1974 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2012, 12:34 PM
  4. Stop cell from updating when a date is reached
    By acampbeb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2012, 08:27 AM
  5. Replies: 1
    Last Post: 04-18-2012, 05:49 PM
  6. Replies: 2
    Last Post: 09-09-2011, 12:30 PM
  7. [SOLVED] Stop the line when 0 is reached
    By Nigel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-14-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1