Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    Calculate Days Open

    Uploaded by

    xy
    The document shows a table with ticket numbers, open and close dates, and number of days each ticket was open. It also notes that the formula used to calculate days open will continue increasing if a ticket does not have a closed date.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Calculate Days Open

    Uploaded by

    xy
    11 views2 pages
    The document shows a table with ticket numbers, open and close dates, and number of days each ticket was open. It also notes that the formula used to calculate days open will continue increasing if a ticket does not have a closed date.

    Original Title

    calculate days open

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows a table with ticket numbers, open and close dates, and number of days each ticket was open. It also notes that the formula used to calculate days open will continue increasing if a ticket does not have a closed date.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    11 views2 pages

    Calculate Days Open

    Uploaded by

    xy
    The document shows a table with ticket numbers, open and close dates, and number of days each ticket was open. It also notes that the formula used to calculate days open will continue increasing if a ticket does not have a closed date.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 2

    Calculate days open

    Ticket # Opened Closed Days open


    10123 30-Jan-21 31-Jan-21 1
    10124 9-Feb-21 19-Feb-21 10
    10125 19-Feb-21 23-Feb-21 4
    10126 2-Mar-21 251
    10127 7-Mar-21 10-Mar-21 3
    10128 21-Mar-21 1-Apr-21 11
    10129 25-Mar-21 26-Mar-21 1
    10130 4-Apr-21 13-Apr-21 9
    10131 4-Apr-21 218
    10132 11-Apr-21 20-Apr-21 9
    10133 13-Apr-21 209
    https://exceljet.net/formula/calculate-days-open

    Note: this formula uses the TODAY function so days open


    will continue to increase if there is no closed date.

    You might also like