Formula return criteria if

I have a sheet with an existing formula in column N.

Please Login or Register  to view this content.

What should be the formule if I want that it returns me in column N:

as long as no date is entered in column M it compares date of today with date in column J an returns *IN PROCESS OK* if date is still before, and returns *IN PROCESS OVERDUE* if date is after today.

Example :

In column J, I have entered date 01/04/2015. No date is in column M. As long as we have not reached 02/04/2015 it returns in column N *IN PROCESS OK*. If we have reached and pass 02/04/2015 it returns *IN PROCESS OVERDUE*. When a date is now entered in column M it returns me *OK* or *NOK* as it do actually.

Thanks for your help

Can please someone help me out with this?

Seems not to work for me. Please see file for more info.

Yeah, I tested it in your workbook.

With this formula in N6:
=IF(OR(C6="",J6=""),"",IF(AND(J6<>"",M6=""),IF(J6>(TODAY()-30),"IN PROCESS OK","IN PROCESS OVERDUE"),IF(M6<=J6,"YES","NO")))

It returns "IN PROCESS OK". What's not working?

Sorry I missunderstood what you mean with replace.

I works like it should be. Just made a little correction. Don't know why the difference of 30, but I think this was a erreur in my request

=IF(OR(C6="",J6=""),"",IF(AND(J6<>"",M6=""),IF(J6>TODAY(),"IN PROCESS OK","IN PROCESS OVERDUE"),IF(M6<=J6,"YES","NO")))

Big thanks to you

The 30 was an assumption on my part, admittedly. I read the date format wrong, and that was one thing that needed to be adjusted. Good catch on that!