Calculation Car In Operation and The Number of Days

[cyliyu]

Need help in my formula.
I am trying to calculate the number of days but my formula not working.
Attached file the sample Excel sheet. Thanks.

 

[Nebu]

HI:

May be this

=IF(OR(M6={0,""}),"",IF(L6="","In Service",IF(COUNTIFS(I6:I$1063,I6,K6:K$1063,K6) <=2,L6-G6,IF(M6=1,"Removed","R"))))

But I am not sure how you arrived at 31 and why the logic is different only for that row.


Thanks

 

[cyliyu]

Thanks Nebu,

Let me try on my master spreadsheet when back to office.
Yes, it should be 43 not 31.

 

[cyliyu]

Thanks Nebu for solving my problem. Tested ok.