how to make excel record cell entry dates

[Guest]

when using Microsoft excel 2003, ive been trying to make a cell remember the
date an entry is made in a different cell. for example: if the letter "a" is
entered into cell A1 i require cell B1 to show the date that the letter "a"
was entered.

 

[Peo Sjoblom]

http://www.mcgimpsey.com/excel/timestamp.html

change from NOW() to TODAY() if you use the formula technique

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

i will try this but i dont think it works as if you alter the date or time on
the clock all the cells return to the same date (current date).

let me know if it has worked for you using this technique.
thanks

 

[Peo Sjoblom]

Did you try it? The reason behind it using circular reference is that it
will look the formula we=hen the condition is TRUE
--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

hello again

ive tried it, but as i suspected the date always returns to the current date
which is not what im trying to do, i need the cell to remain at the date when
the referenced cell was populated. is there a way that this can be done; i.e.
if cell A1 was populated with the letter "a" on 10/06/06, then cell B1 will
always remain 10/06/06.
the formula im trying to use in cell B2 is; =IF(A1="a",TODAY(),"") ive also
tried this with NOW() in place of TODAY() with the same result.

Thanks.

Hoyt

 

[Guest]

Ive tried it again and ive now got it to work. Woo Hoo!
i forgot to check the Iteration box last time, well im an idiot.

thanks for the help on this

Cheers Hoyt