Having Data in Fields Expire. (Excel)
Russell:
Assuming your data contains a date and further assuming you want data older
than 90 days to be "expired", you could put the following formula in the next
available column to the right of your data... "IF(A1<=TODAY()-90,"Exp"," ")"
This will put "Exp" in cell for data that is equal to, or older than, 90
days. You could then delete the expired data, assuming your formulas
elsewhere would not be affected.
Hope this helps.
"RussellC" wrote:
I have older data in an Excel Document that is no longer needed. This
spreadsheet is a continuous log of information used by my organization. Is
there something I can set up to have the un-needed data in the fields expire
and still have a seamless transition when inputting new data?
|