Quote:
Originally Posted by Spencer101
Hi,
How about:
=IF(E4="","No",IF(E4<=TODAY(),"Expired",IF(E4TODA Y(),"Yes")))
One thing I will mention is in your original formula you should get rid of one of the equals. If you say <=today in one statement then =today in the next, there is some overlap and today's date could theoretically appear in either statement. I've taken the last equals out in my suggested formula above as due to the order the second one would be ignored anyway.
Let me know how this works for you.
S.
|
It worked!
Thank you both so much for replying so quickly, and for the suggestions. I think my database is finally ready and my sanity is still intact, with your help of course :)
Similar Threads
Threaded Mode
