+ Reply to Thread
Results 1 to 4 of 4

Days Past Due if Not Closed Formula

  1. 11-16-2022, 10:17 AM #1
    SU30
    SU30 is offline
    Registered User
    Join Date
    03-29-2022
    Location
    MI
    MS-Off Ver
    365
    Posts
    16

    Days Past Due if Not Closed Formula

    Looking to add a formula to populate how many days past due a task is based on set dates and status.


    Document added for reference
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-16-2022, 10:24 AM #2
    The_Snook
    The_Snook is offline
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Re: Days Past Due if Not Closed Formula

    Hi SU30,

    Pop this in cell E2 and copy it down.

    =IF(F2<>"Closed",TODAY()-D2,"")

    Regards,

    Snook
    Reply With QuoteRegister To Reply
  3. 11-16-2022, 10:29 AM #3
    SU30
    SU30 is offline
    Registered User
    Join Date
    03-29-2022
    Location
    MI
    MS-Off Ver
    365
    Posts
    16

    Re: Days Past Due if Not Closed Formula

    Thank you, Snook!
    Reply With QuoteRegister To Reply
  4. 11-16-2022, 10:36 AM #4
    The_Snook
    The_Snook is offline
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Re: Days Past Due if Not Closed Formula

    You're welcome SU30, I'm happy to help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] i need to Calculate the average days the tickets have been open in the past 30 days
    By Reece_Norman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2022, 12:48 PM
  2. [SOLVED] Formula to calculate days is open and closed
    By Defyrider2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2018, 06:13 AM
  3. Help with Past 30 days formula
    By jbroulette in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2018, 12:41 AM
  4. Aging report formula not working for 0-30 days past due
    By Lorir1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-04-2015, 01:12 PM
  5. [request] A formula to calculate # days past since (date) then highlight column
    By Zeroable in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-22-2015, 07:18 PM
  6. Formula for # of days past due
    By markeedee311 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2014, 02:24 PM
  7. [SOLVED] Formula for updating 30.60.90 days past due that updates for new entries
    By RArchie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2013, 08:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1