Hello everyone,

I am wondering if someone may be able to offer a kind spot of advice. I can't seem to find any information relating to the query I am after. In essence I would like to achieve the formula as follows:

TRUE =IF(CELLBLANK then Calculate C1-C2 unless C3 is greater than C2 then calculate C1-C3
FALSE = C1-C4

Formula: copy to clipboard 
=IF(C4="",C1-C2>C3,C1-C4)


If anyone can help tidy this up and show a solution it would be great. The cells are dates. Therefore this should provide me the duration between the two. Thanks for your time.