=NOW() For date and time
=TODAY() For just the date

Both will change to reflect the current data the file is open.

Vaya con Dios,
Chuck, CABGx3



"grahammal" wrote:


How do I program a cell to display the date and automatically update it
each day.
I assume it looks at system date but i'm not sure how its done.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=547408