Automaticly change date in Wroksheet

  • Thread starter Thread starter Sloandog
  • Start date Start date
S

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!
 
Hi

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

="As of: "&TEXT>(NOW(), "ddMMMyy")
 
-----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!
.
Click to expand...
 
Back
Top