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 06, 2021

    Sharon_Dquest1 

     

    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.

     

     

Resources