Formula to show days overdue

[Shazz]

Hi All,

I am looking for a formula to shows days over due in Column E2 from a date typed in D2, does anyone know of a simple Formula.

Thanks very much

Shazz
xx

[CheshireCat]

How about:

=MAX(0,TODAY()-D2)

[Shazz]

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

[Simi]

try putting this in cell E2

=IF(ISBLANK(H2),-(TODAY()-D2),-(H2-D2))