Results 1 to 4 of 4

Thread: Formula to show days overdue

  1. #1

    Formula to show days overdue



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    How about:

    Code:
    =MAX(0,TODAY()-D2)

  3. #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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Example.jpg 
Views:	40 
Size:	83.7 KB 
ID:	1143  
    Last edited by Shazz; 2013-02-19 at 04:42 PM. Reason: Upload Image

  4. #4
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    try putting this in cell E2
    Code:
    =IF(ISBLANK(H2),-(TODAY()-D2),-(H2-D2))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •