Formula for Days Overdue if not Completed

**excelnewb02** · 10-28-2010, 05:31 PM

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.)

**Cutter** · 10-28-2010, 05:35 PM

Try this:

Please Login or Register  to view this content.

**Richard Buttrey** · 10-28-2010, 05:39 PM

Hi,

Try in B2 and copied down

Please Login or Register  to view this content.

HTH

**excelnewb02** · 10-29-2010, 11:30 AM

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

**ranga10** · 09-10-2012, 11:26 PM

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)

**Richard Buttrey** · 09-11-2012, 04:51 AM

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.