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...
You will find it attached. And if I had any common sense yesterday I wouldn't have removed everything. Thanks!
I may be missing it, but this new one still is basically blank, isn't it? Here's a screen grab... Data: Please show some representative data, as asked before, in rows 4-6 at least, 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.
I see the formula in Column I, but no other.... but to see how you store the dates, since that's what you've asked about...etc.