With the table as you have it, it is possible only using VBA code checking every entry made into sheet, was it in column Status of table or not, was the entered value "Open" or "Closed", what was content in cell in Aged column in same row (formula or value), and depending on result of those checks, leaves the content of cell in column Aged unchanged, or replaces it with current value in cell.



When you want to do it with worksheet formula, then you must have a column, where you enter 'Closed date' (Look in attached file - I left Status field there, but now is no need for it anymore - when the ClosedDate is not empty and is less or equal as today's date, the case is closed, otherwise it is open).

Attached Files

BOOK_ONE.xlsx (9.0 KB, 13 views)

Thank you Arvilaanemets. case is solved!. but still need [status] for filtering purpose.

You can have it calculated - no need for manually editing Status column. And of-course to avoid any confusion at data entry, move the Status column to rightmost position in table.