PDA

View Full Version : Solved: Date and time



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

mdmackillop
10-06-2009, 04:16 PM
I can't see a way to do that without VBA.

nepotist
10-07-2009, 06:29 AM
ok , as I dont have any controls in the spread sheet how would I do that In VBA ?

mdmackillop
10-07-2009, 08:04 AM
Try this