Hi Sarah

You have 2 answers giving you =TODAY(), which is quite correct.
Obviously this will change when you open the file tomorrow.
if you just wanted to insert today's date into a cell and have it fixed,
then type Ctrl ; (Control + semicolon)

--
Regards

Roger Govier


"Sarahbkelly" wrote in message
...
Is there a way to automatically fill a cell with todays date?