This requires vba ..
Try this previous post by JE McGimpsey:
http://tinyurl.com/97xj9

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jane" wrote in message
...
column A is for date and column B is for data entry. I want column A to
populate with date when dat is entered into the adjacent cell in column B.

Currently, in column A, I have:
=if(b10,today(),"").

The date does populate when I enter data in column B BUT every day I
proceed
down column B and enter data, the date changes in every cell in column A
to
the SAME DATE.
How can I have the date stay at the date on whcih the data was entered?
thanks! jane