WE REQUIRED TAT FOR E COLUMN

[Chandram]

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

 

[vletm]

Chandram
Should everyone know, what would be 'TAT'?

 

[Chandram]

Turn Around Time

 

[AliGW]

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

 

[bosco_yip]

Or.........



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

 

[Peter Bartholomew]

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.