1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

WE REQUIRED TAT FOR E COLUMN

Discussion in 'Ask an Excel Question' started by Chandram, Jul 11, 2018.

  1. Chandram

    Chandram New Member

    Messages:
    3
    Dear Sir,
    I required TAT in column E,
    With collected date - Regristration Date, If collection date is not available we are unable to get TAT, so kindly resolve this.

    if collection date is blank how we get TAT
    please consider as "blank = today's date"

    how we get TAT with blank columns is there any chances to get TAT please help me.
    I am applied if condition formula also but not get that TAT

    Attached Files:

    Last edited: Jul 11, 2018
  2. vletm

    vletm Excel Ninja

    Messages:
    4,056
    Chandram
    Should everyone know, what would be 'TAT'?
    Peter Bartholomew likes this.
  3. Chandram

    Chandram New Member

    Messages:
    3
    Turn Around Time
  4. AliGW

    AliGW Active Member

    Messages:
    252
    How do you want TAT calculating if there is no collection date? From today's date? You need to be clear - tell us what your expected outcomes would be in these cases.

    Is this what you want?

    =IF(C2="","Incomplete",C2-B2&" days")

    Or this maybe?

    =IF(C2="",TODAY()-B2,C2-B2)&" day(s)"
  5. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    1,909
    Or.........

    upload_2018-7-12_15-4-57.png

    In E2, copied down :

    =IF(B2="","",IF(C2="",TODAY()-B2,C2-B2))

    and,

    >> E2 >> custom format cell >> Type box enter: [=1]0" day";0" days"

    All copied down

    Regards
    Bosco

    Attached Files:

    Thomas Kuriakose likes this.
  6. Peter Bartholomew

    Peter Bartholomew Active Member

    Messages:
    381
    Basically the same solution but I would encourage you to collect data using Tables, which grow and format automatically, freeing the user from the need to extend the formula fields. It also provides meaningful notation for referencing data.
    = IF( [COLLECTED DATE],
    [COLLECTED DATE] - [REGISTRATION DATE],
    [TODAY DATE] - [REGISTRATION DATE] )
    In this case, no check on the registration date is needed because the record simply wouldn't exist if the date were not present.

    Attached Files:

    Last edited: Jul 12, 2018
    Thomas Kuriakose likes this.

Share This Page