timestamp

[Bradbu]

Hi
I have a spreadsheet and I want to create a timestamp when the status is Open and a seperate timestamp when the status is closed. The timestamp I have created works except when the status moves from Open to closed the Timestamp that was created when it was first opened disappears and I need it to remain in place. Feel this can be achieved either by updating my formula or by adding a seperate column which retains the previous status. I have a picture of my spreadsheet and would love it if someone could help me with this. The forumla you can see is:

=IF(E6=$G$3,IF(G6<>"",G6,NOW()),"")

Many thanks in advance

 

[awoohaw]

I think the NOW() functions updates with every calculation action. So, it will change everytime you do something in the worksheet, regardless of the status being closed
Do you want a VBA solution?

 

[Bradbu]

I think the NOW() functions updates with every calculation action. So, it will change everytime you do something in the worksheet, regardless of the status being closed
Do you want a VBA solution?

I am not used to using VBA but I'll definitely take a VBA solution if you are able to provide one - Many thanks!

 

[Joe4]

If you would like help coming up with a VBA solution, please post a screen print that shows the row numbers and column letters, so we can see where all your data resides, and where exactly you would like these time stamps to go.