If Command query

[kgfklee]

I have a spreadsheet to confirm compliance events are met.

I have set up an IF COMMAND and I want to determine whether a compliance event has been met.

So the command I have set up requires that where the "date filed" is less than the "Deadline date" then compliance has been met (i.e. "Y"). and where the "date filed" is more than the "deadline date" then compliance has not been met (i.e. "N"). I want to leave this cell blank if the action is still pending (i.e. where "Date Filed" is still blank but it is showing as complied.

I hope that I haven't confused anyone.

Assistance would be really appreciated. Thanks.

[FDibbins]

Maybe something l;ike this....

=IF(Date Filed="","",if(Date Filed<deadline date,"Y","N"))

[kgfklee]

This worked perfectly. Thank you so much.

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)