Hello happy campers,

Hopefulyl this will be fairly simple to resolve

In cell B2 i have yesterdays date, in Cell C2 i have todays date, in Cell D2 i have 
=C2-B2
giving me the difference in days between the 2.
I then changed this to read - 
=IF(AND(B2="",C2=""),"",C2-B2)
which also works fine, because if one or both of the cells (c2, b2) are empty, then i dont see a zero in D2.
I then changed it again to - 
=IF(C2="","",IF(AND(B2="",C2=""),"",C2-B2))
It was then changed again to 
=IF(AND(ISBLANK(C2),B2="",C2=""),"",C2-B2)
Basically what i want is - If B2 is the same date as C2, show me 0.5 in D2
If they are both blank, show me nothing
If B2 has an entry but C2 is blank, show me nothing
If B2 has one date, and C2 has a later date, show me the difference.

Kind Regards, galvinpaddy.