how do you auto populate the date in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need the date to change automatically on a daily basis - how do i do this -
i know that you can auto populate the date in WORD so i figured you could do
it in EXCEL
 
try =today() in a cell
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Be aware that =TODAY() is volatile......in that if you put it in a file
today, and save the file. When you open the file again it will read the date
on the day you open it, not the date it was originally put in the file. Hold
the Ctrl key and press the semicolon key to get a date-stamp that will be
today, and stay the way you set it no matter when the file is opened again.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top