Solved: Date and time

[nepotist]

Hello I am preparing a spreadsheet a basic one..

I have a column that has a data validation to a list .
When a user selects a value from the list, I would like to update the cell next to it with the date and time the user selected a value.
I used a if statement
if (cell <>"",now(),"")
guess that dosent work as every time I update other cell in the same column all the date and time get updated to the current time and date.
I want the date to be static .. how do I do that. I dont want to write a VBA code for it , was wondering if there is any excell formula that does this

thank you

[mdmackillop]

I can't see a way to do that without VBA.

[nepotist]

ok , as I dont have any controls in the spread sheet how would I do that In VBA ?

[mdmackillop]

Try this