+ Reply to Thread
Results 1 to 5 of 5

Setting age of item-calculating submission date age

  1. #1
    Registered User
    Join Date
    09-24-2018
    Location
    North Carolina, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Setting age of item-calculating submission date age

    We need to track how long an application has been sitting before it has been resolved. In the attached sample, you can see that the formula ties the date of submission to 'today's date', which continues to grow with time. I'd like the timer to stop when a date is entered into the close date.

    Is it possible to have age of item calculate from today if no data entered into close date and calculate from close date if that cell has been filled?

    thank you!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Setting age of item-calculating submission date age

    Try this modification to the formula in G6.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Registered User
    Join Date
    09-24-2018
    Location
    North Carolina, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Setting age of item-calculating submission date age

    Ta Da! Thanks so much. that was the fix!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Setting age of item-calculating submission date age

    You are welcome. Glad to help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    09-24-2018
    Location
    North Carolina, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Setting age of item-calculating submission date age

    thanks for the reminder. I was trying to find that last night.

+ 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. [SOLVED] Determine Payment Due Date with Submission Date
    By Hikari in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-13-2021, 10:37 AM
  2. [SOLVED] Dynamic Database to Find Closet Submission date
    By Shermaine2010 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-17-2018, 11:56 PM
  3. Getting Item Rate from worksheet and calculating total item rates
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2015, 04:17 PM
  4. [SOLVED] Match submission date to Employee number for each Quarter
    By pytheus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2014, 10:33 PM
  5. Static Date for submission
    By sgeorge6 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-27-2014, 01:30 PM
  6. Points calculation based on report submission date
    By Kristo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 09:42 PM
  7. Points calculation based on date submission of reports
    By Kristo in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-14-2013, 08:37 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