#NUM! error

BobBridges · #4 02-02-2014, 06:43 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automation error Unknown error" message once they open the Excel file	hlina	Excel	1	10-08-2013 09:14 PM
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!!	bennypryde	Office	1	01-05-2012 03:33 PM
Runtime error 5487 - Word cannot complete the save to to file permission error	franferns	Word	0	11-25-2009 05:35 AM
Receive error cannot open this form because an error occurred in BCM 2007	bornhusker	Outlook	0	06-01-2009 10:28 AM