+ Reply to Thread
Results 1 to 6 of 6

Formula for Days Overdue if not Completed

  1. #1
    Registered User
    Join Date
    10-28-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    16

    Formula for Days Overdue if not Completed

    I'm trying to format a worksheet to show how many days overdue certain tasks are, and running into a couple of issues. The sheet is set up with Due Dates in Column A, Days Overdue in Column B, and Date Completed in Column C. My first thought was just to use as simple a formula as possible in Column B =Today()-A2. This worked alright for tasks that already had Due Dates assigned, but if Column A was blank I'd get a high number in Column B. I also realized that tasks will continue to show as overdue even after I enter the completed-on date in Column C. Is there a relatively simple way to tackle this formula? Thanks in advance for suggestions. (I've attached an example with the column headings I want to use.)
    Attached Files Attached Files

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,454

    Re: Formula for Days Overdue if not Completed

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,779

    Re: Formula for Days Overdue if not Completed

    Hi,

    Try in B2 and copied down

    Please Login or Register  to view this content.
    HTH
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    10-28-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Formula for Days Overdue if not Completed

    Thanks so much for your help. The second formula seems to do the trick.

  5. #5
    Registered User
    Join Date
    09-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Formula for Days Overdue if not Completed

    This formula is great - however is there any way to only have a value show up if it hasnt been paid and IS overdue. Rather than a negative value showing (Not due yet)

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,779

    Re: Formula for Days Overdue if not Completed

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies. In addition your request has an additional element that isn't in this from two years ago so it makes sense to post your specific request as a new one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1