How to keep the current date constant?

[Akshay Bhagat]

Hi

Kindly see the table below.

I am creating a sheet, where when a user enter value in the column named "Name", the date column gives output of the current date in the format given below.

A B
DATE Name
29715
Abhilash Rout

29715
Deepak Bhatia

29715
Abhilash Rout

29715
Deepak Bhatia

29715
Amit Kumar

I am using the below formula in the date column

=if(LEN(B2)>0,today(),"n/a")

But the date keeps on changing the next day. How can I keep the date constant when the name column is updated for the first time and then the date is constant for every time I edit the sheet.

P.S.: I know its because of today function. It gives current date everyday. Kindly suggest some alternative.

 

[Hui]

What you want to do is called Date Stamp or Date Stamping
But also Time Stamping

Try using the Google Custom Search box at the top right of this page Search for Date Stamp you may find

http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/