I did that from memory, and you know, even as I wrote it I had a niggling suspicion that I should look it up. But no, I thought to myself, I KNOW this stuff; I don't need no stinkin' manual! He's right, of course, jimboba; it's not ERROR, it's ISERROR.
I still think, though, that it's even simpler to use the last one:
Code:
=IF(J3<J5,"Expired",INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days")
<Double take> IFERROR? I don't think I ever knew about that one. ...Oh,
cool! (I just looked it up.) Ok, jimboba, here's another alternative:
Code:
=IFERROR(INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days","Expired")
Yeah, probably even better.