• 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...

  • 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

Chandram

New Member
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
 

Attachments

Last edited:

AliGW

Active Member
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)"
 

Peter Bartholomew

Well-Known Member
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.
 

Attachments

Last edited:
Top