nepotist
10-06-2009, 01:17 PM
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
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