creating a "time stamp"

[Dusty]

Hi. I'm looking for help in creating a time stamp on a
spreadsheet.

Here's what I have:
shared spreadsheet
group 1 enters information for group 2
group 2 uses information, then "signs" it as complete.

I'm looking for a formula that will post the time when
group 2 "signs" the spreadsheet; the key is the time would
not change "on update" (or after saving) after
initial "stamp".

Currently using that is not working so the time does not
change:
IF(A2="Y",NOW(),"")

Thanks!

 

[Frank Kabel]

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