Comparing 3 Different Dates

[azwinelover]

I have a spreadsheet that can have 3 different date fields. I need to record the # of running days and display them. Here is a mockup: We enter the (Date In) field when the vehicle is brought in and also enter the (Due Date) field at the same time, we need to track the continuous days it is being worked on, but once we finish the vehicle and enter data into the (Date Out) field, we need the (Days in Service) field to reflect the total # of days it was worked on along with putting the # of days it is overdue, if any in the (Overdue) field. My big hangup is when I enter the Date out field, the date keeps on running no matter what day we are currently on, I need the "counter" to stop once I enter data into the Date Out field.

Date In Due Date Date Out Days in Service Overdue
2/1/11 2/18/11 2/17/11



I've attached the spreadsheet for anyone to review.

Thanks for all your help