如何反映与Excel中选择的列表项对应的特定单元格的日期？

Basically I have an excel sheet used for tracking statuses in hiring, where there are around 5 statuses (Briefing, Advertising, Shortlisting, Selection, Offering) and against each vacancy there's a status cell as a list of the above statuses and it's changed manually based on the status of the vacancy.Basically I have an excel sheet used for tracki