How about:
Code:=MAX(0,TODAY()-D2)
How about:
Code:=MAX(0,TODAY()-D2)
Sorry, I put this in and it is not quite what I wanted, it works fine but I also want it to stop caculating If I type a date in H2
I have attached a screenshot as an example.
Shazz
Last edited by Shazz; 2013-02-19 at 04:42 PM. Reason: Upload Image
try putting this in cell E2Code:=IF(ISBLANK(H2),-(TODAY()-D2),-(H2-D2))
Bookmarks