You want the IF and ERROR functions. The long and complex way of doing it is this:
Code:
=IF(ERROR(INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days"),"Expired",INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days")
Me, I'd put this in K7:
Code:
=INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days"
Then in J7 I'd just say =IF(ERROR(K7),"Expired",K7).
On second thought, you could make it simpler. Since it's the DATEDIF function that's generating the error, you could say
Code:
=IF(ERROR(DATEDIF(J5,J3,"d")),"Expired",INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days")
Or even just
Code:
=IF(J3<J5,"Expired",INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days")
Yeah, that'd be best.