Forum Discussion
Using TODAY()
In my lab we document the expiration date of items every day we use them in excel. I want it to highlight when an item is expired so that the item is no longer used. If today is 1/4/21 and an item ex...
Here is a sample sheet. Thanks!
Can you post a sample sheet that isn't totally blank?
@adversi asked for "no sensitive data," but (taking the risk of reading minds here) I doubt it meant "no data at all." Just omit proprietary data, but give us something to work with that represents the kind of data, some of which is equipment that has expired, some of which hasn't yet, etc..... that would enable us to test functions, conditional formats, and so forth. If you could include the formulas you have developed, even though you're not satisfied, it still helps us help you.