Need the right Nested IF formula for this condition

[zicitron]

Hi all,

Cell K2 is my Date of Arrival, Cell L2 is my Date of Departure.

I need to a formula in cell M2 that will do the following: if K2 < or = TODAY AND L2 > or = TODAY, then it outputs "In House"; if K2 > TODAY, then it outputs "Not Yet Arrived"; if L3 < TODAY, then it outputs "Departed".

I've tried playing with the Nested IF statement but just can't get it right!

 

[njimack]

=IF(L2 < TODAY(),"Departed",IF(K2 > TODAY(),"Not Yet Arrived","In House"))

 

[zicitron]

Thanks a lot, njimack!