Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?

ANSWER:

There is a very simple way to do this that doesn't require Macros enabled or VB script. Use the IF function with the date or date & time formula embedded.

=IF(B1=0,"",TODAY()) this will include static date
=IF(B1=0,"",NOW()) this will include static date & time

I use this and it works flawlessly.

good luck.