| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having Data in Fields Expire. (Excel)
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
| Fix too few data fields error message when merging excel and word | Excel Discussion (Misc queries) | |||
| seeking way to expire excel documents after certain date in Office | Excel Discussion (Misc queries) | |||
| Data population between excel and access - Errors on missed fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
