sharepoint online – How to calculate the modified date for a specific column

I have a list in SharePoint where people will change the status to “closed” when complete. I want to have a column that populates the date this column was changed to “closed”

Sometimes entry is changed after being closed, so I can’t always rely on the “last modified” view