Completion dates that show past due and recognized if already completed and is late

**Cgoyette** · 04-08-2014, 03:55 PM

I cant seem to figure out the formula to determine if a vehicle is on time, past due or late.

Todays Date - Start Date - Est End Date - Completion Date - Status

Status is where I want to determine if the vehicle was

on time (est end date and completed date <=)

Past Due(veh exceeds est competed date and has no completion date)

Late (Veh is done but exceeded the est end date)

I used the today() for the todays date but its the LATE formula that keeps making me crazy.

I could use the help.

Thank you
Curt

**alansidman** · 04-08-2014, 04:47 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Cgoyette** · 04-08-2014, 05:09 PM

Attached file

**easyexcelanswers** · 04-08-2014, 05:16 PM

I think I have got it
=IF(0<D2<=C2, "on time",IF(AND(B2>C2, D2=""), "past Due", IF(D2>C2, "late", "on time")))cars.xlsx cars.xlsx

**Cgoyette** · 04-08-2014, 05:42 PM

=IF(0<D2<=C2, "on time",IF(AND(B2>C2, D2=""), "past Due", IF(D2>C2, "late", "on time")))

sorry doesn't work

I get on time and late but it should have some PAST dues since the vehicle is not done yet.

The vehicles that do not have a completed date should be shown as past due. No value is in that cell and that may be what the hang up is.

This one is killing me.

Curt

Completion dates that show past due and recognized if already completed and is late

LinkBack

Thread Tools

Rate This Thread

Display

Completion dates that show past due and recognized if already completed and is late

Re: Completion dates that show past due and recognized if already completed and is late

Re: Completion dates that show past due and recognized if already completed and is late

Re: Completion dates that show past due and recognized if already completed and is late

Re: Completion dates that show past due and recognized if already completed and is late

Thread Information

Users Browsing this Thread

Similar Threads

Conditional Formatting with approaching due dates and completed dates

[SOLVED] Template for tracking project completion dates and simple metrics? % Completed on time

[SOLVED] Move Rows from one worksheet to another if 30 days past completion date

[SOLVED] Add late fee. Inserting text and numbers in sep clumns IF date entered is past 20th

Overdue/late completion/completed tasks

Bookmarks

Bookmarks

Posting Permissions