What do you mean by "auto date"? The =TODAY() function returns the current
date, and =NOW() returns the current date and time. Both update whenever a
calculation is made.
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
