Calculate days between 2 dates and returning a blank cell if there is missing data

[j_dinh]

Hi there,

I previously wrote a post about a similar issue, however now I am adding another scenario into the equation, so again I am stuck on calculating processing days between dates unfortunately!

Please see attached spreadsheet. I am having issues with column D. I only need a result in column D if there is not already a result in column C.

Also if there is missing data in columns A & B, I need column D to remain blank.

Any help would be most appreciated!

Thanks

Jaz.

[benishiryo]

hi Jaz, is this what you need? in D2:
=IF(OR(C2<>"",A2=""),"",TODAY()-A2)

[j_dinh]

Yes, thank you so much!! I've been trying to figure it out on my own for ages but kept getting stuck! Really appreciate your help & quick response