Automaticly change date in Wroksheet

[Sloandog]

I am trying to get a cell in my excel spreadsheet to
automatically put the current date in it. I.e. Each day
I print it out, the "As of" date it will change. I knoqw
how to get it to take a date already entered into the
spreadshhet by the following, ="As of: "&TEXT
(F5, "ddMMMyy") but I want todays date to be
automatically input. Can anyone give me some hint on
this one? thanks!

 

[Chip Pearson]

Try something like

="As of "&TEXT(NOW(),"ddMMMyy")

 

[Richard Daniels]

Hi

Use the now() function. So instead of F5 your fomula
will look like

="As of: "&TEXT>(NOW(), "ddMMMyy")

 

[Sloandog]

-----Original Message-----
I am trying to get a cell in my excel spreadsheet to
automatically put the current date in it. I.e. Each day
I print it out, the "As of" date it will change. I knoqw
how to get it to take a date already entered into the
spreadshhet by the following, ="As of: "&TEXT
(F5, "ddMMMyy") but I want todays date to be
automatically input. Can anyone give me some hint on
this one? thanks!
.