an easy way is to make cell B1 have =today() be in it, but format it
to white text.
then do conditional formatting that if
A1<""
then the text changes to black and the date can be seen. that way the
date is always there, you just don't see it until you enter data into
cell A1.
hope that helps.
:)
susan


On Mar 6, 12:08*pm, aspect30
wrote:
How can I make today's date auto fill in a cell upon entering data in another
cell. I would like the cell B1 that contains the date to remain empty until I
enter data in cell A1.
Please advise.
Thanks.