I have formula that reads a cell if another cell equals today. Is there any way that this data can automatically frozen, so that the data remains when I open up the spreadsheet tomorrow.
Example: =IF(A4+TODAY(),B4), where B4 is a date that I wish to capture a value and B4 is the reference value, which will change daily. I have a list of dates that I wish to self populate, but not lose the data when it changes to a different date, I hope this makes sense.
Bookmarks