Using changes in a drop down list in a single column to date stamp changes in that column.

Hi All
I'm new to this so apologies if I don't follow protocol.

I am a basic excel user and want to use a spreadsheet to track progress of work through a series of activities in a process.
This will be used by a number of team members. So I would like to keep the recording simple by the use of a drop down to set the status of the work and date stamp a column relating to that status when that status changes, so you end up with a series of columns representing steps in the process with dates they were undertaken. This is done simply by team members just changing the status column. I have tried simple if formulas but as you would expect when the status changes the previous date changes.

I have no experience of macro's. Any help would be appreciated.

May be a workbook with data and desired results would help.

Thanks for the advice on using a workbook, can you advise how this would solve the problem of loosing date stamps in activity fields
when the status field is changed? As I said I am a basic excel user.

Thank you for the advice. I thought that might be the case.