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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Shaggy" wrote in message ...
| I need the date in "B5" to be Static according to the date that the
| data was entered into "A5" (As long as the Data is greater than 1)
|
| EG: "A5" = 19000 (Which i type in on 21 Aug 2006) so "B5" = 21 Aug 2006
| "A6" = 20001 (Which i type in on 23 Aug 2006) so "B6' = 23 Aug 2006
| but "A5" should stll be dated as 21 Aug 2006
|
| This is the formula I entered into "B5", "B6" etc yesterday
| =IF(A5 1,NOW(),"")
| =IF(A6 1,NOW(),"")
| But this updates the date to todays date and doesnt stay static for the day
| that the data was into the relevant "A" cell.
|
| Thanks for any help in advance
| Shaggy