Thanks, Harold, I was apparently getting stuck on the INT. Also < is treat as <= for some reason, which was messing up my first test case. Had I rearranged my test cases I would have discovered that and saved some effort. This is the function that I am using now:
=IF(A2-NOW()+1<0,"Expired",INT(A2-NOW())+1) Thanks for your help. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
