Formula to show days overdue

Shazz

New member
Joined
May 9, 2012
Messages
15
Reaction score
0
Points
0
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
 

Shazz

New member
Joined
May 9, 2012
Messages
15
Reaction score
0
Points
0
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
 

Attachments

  • Example.jpg
    Example.jpg
    83.7 KB · Views: 46
Last edited:

Simi

New member
Joined
Feb 10, 2012
Messages
190
Reaction score
0
Points
0
Location
Utah, USA
Excel Version(s)
Version 2002 Build 12527.20194
try putting this in cell E2
Code:
=IF(ISBLANK(H2),-(TODAY()-D2),-(H2-D2))
 
Top