Use the formula =TODAY()
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"txdude1" wrote in message
...
Basically I need to know how to make a date update automatically. For
example, the date column reads 12/19/2008 (Friday). Then the next day
(Saturday 12/20/2008), it will change to read 12/26/2008. Is this
possible?