Formula to Calculate Days Overdue, using Due Date/Date Returned/Extended Date

Loan tracker snippet.JPG

Using Excel 2013

I would really appreciate help with this writing a function to return the number of days overdue based on whether or not the item has been returned or extended. The loan date, return date and extended date are entered manually, the due date and days overdue are calculated. I'd also love to keep this clean, so the "Value!" error doesn't populate in blank rows.

I've shown the tests that this must match, but I'm just not good at formulating logical functions (and have no experience with programming )

Try this

Formula:

Please Login or Register  to view this content.

Still the same results, thanks! This might help with what I'm looking for. The formula must meet the conditions:

If Date Returned and Extended date are blank, calculate days overdue from todays date minus Due Date.
If Date Returned is NOT blank, do not calculate & return a blank field.
If Extended Date is NOT blank, calculate days overdue from the Extended Date and Today.
Do not return - or 0 as a result.

How do I go about uploading a workbook, Richard? When I go to Insert Image, I am only provided the options for jpg, jpeg, gif or png. I did search the help faq on this, but insert image was all that I found as an option. Your guidance would be appreciated!

Try this in F2

Formula:

Please Login or Register  to view this content.

Oops, I missed copying the formula down. It DOES clear the value error, thanks!!!!