Nested If statement for Date Comparison

I’ve been puzzling over this for a couple of days, nearly there but I really don’t think I’m going the right way about it.

Column A is not needed in this problem.

Column B is the Action Target Date (ATD) – forecast Action Completion Date
Column C is the Action Proposed Closed Date (PCD) –day the action is completed
Column D is the Executive Meeting Date (EMD) – Day signed off by the Committee.

The Cell = Date of the Next EMD

Column E = results

I need to;
Look at the EMD and if it is occupied, leave the Result either Empty or have the word ‘Closed’, or
Look at the PCD and if it is Empty, make the Result ‘No PCD, or
Look at the ATD and compare it with the EMD Look-up date and if the ATD is earlier than the Look-up date, make the Result ‘Early’, if not make the Result ‘Late’.

I have the following that nearly works

=
IF(OR(D2<>"","Closed",""),
IF(OR(C2<>"","No PCD",""),
IF(F2>=N2,"Early","Late")))

But it gives me ‘Early’/’Late’ where I should have ‘Closed’ and ‘FALSE’ where I should have ‘No PCD’

Try this in E2:

=IF(D2<>"","Closed",IF(C2="","No PCD",IF(B2<'EMD Date'!$D$3,"Early","Late")))

then copy down.

Hope this helps.

Pete

Pete,

That works, my very many thanks.

Bryan

Glad to help, Bryan, and welcome to the forum.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete