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!
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!