Try this out in cell B2 (assumes other data is on row 2):

=IF(V2="","Open",
IF(AND(AD2<"",AE2<""),"Cancelled",
IF(AND(AC2<"",AE2<""),"Closed/BER",
IF(AE2<"",
IF(J2K2,"Closed/No","Closed/Yes"),
IF(J2K2,"Complete/No","Complete/Yes")))))

This is all one formula - I've just split it at each IF to make it
easier to read. It doesn't test for dates specifically, just whether
the cells are empty or not. Copy down if it meets the criteria.

Pete