Hello!!

I'm working with a spreadsheet to manage the timely completion of work orders. I need a formula that results in Early, OK or Late depending on the Completion Date and refering to the completion period, for example:

FROM TO COMPLETION DATE EARLY/LATE
01/01/06 - 01/31/06 02/06/06 LATE

I have tryed so many different ways but nothing

Help me please!!

Howdy, and welcome to the board.

Can you attach a sample file?

Are the "From" and "Completion Date" in separate columns?

I'm trying to attach the excel spreadsheet but i get an error message.

Yes they are to different columns


thanks

If From Date is in B3, To Date is C3, and Competion Date is D3, then put this in cell E3

=IF(D3>C3,"Late",IF(D3<C3,"Early","OK"))

it always returns late

thanks

My mistake I was using 06 intead of 05
that is why it was always late!!!

Thansk for all your help, I really appreciate it!!

Glad it worked. And thanks for coming back to verify that!

Have an excel-lent day!

You too!!

Thank you very much for everything!!