Hi,
Dotan Cohen schrieb:
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)
You may also try the TODAY function which returns the current date
without the time. So there is no need to round.
=IF(A2<TODAY();"Expired";A2-TODAY())
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
