Forum Discussion

Sharon_Dquest1's avatar
Sharon_Dquest1
Copper Contributor
Jan 04, 2021

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...
excel
Formulas and Functions
adversi's avatar
adversi
Iron Contributor
Jan 04, 2021

Sharon_Dquest1 Can you provide a sample workbook with no sensitive data to review? My best suggestion is to create a new static column that tracks the "Date Last Used" so prevent the TODAY function from incorrectly flagging expired items

  • mathetes's avatar
    mathetes
    Gold Contributor
    Jan 07, 2021

    Sharon_Dquest1 

    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.

     

     

Resources