Formula to show days overdue

S

Shazz

New member

Joined

May 9, 2012

Messages

15

Reaction score

0

Points

0

• Feb 19, 2013

• #1

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

New member

Joined

Dec 30, 2011

Messages

121

Reaction score

0

Points

0

Location

Victoria, Canada

Excel Version(s)

Microsoft Excel 2013

• Feb 19, 2013

• #2

How about:

Code:

=MAX(0,TODAY()-D2)

 

S

Shazz

New member

Joined

May 9, 2012

Messages

15

Reaction score

0

Points

0

• Feb 19, 2013

• #3

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

  83.7 KB · Views: 46

Last edited: Feb 19, 2013

S

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

• Feb 28, 2013

• #4

try putting this in cell E2

Code:

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