I'm not aware of any such function, but there is another way to freeze the
date. When you open a new invoice from the template, click on the date cell
and press these keys: Ctrl and semicolon. This will change the entry to a
permanent date.

"- ML -" <- ML wrote in message
...
I've created a lovely invoice in Excel for my company. When I generate a
new
invoice from the template it puts in the date using the TODAY() function,
but
unfortunately this updates if I ever open the invoice again to look at it.

In Word there is a "CREATEDATE" function which inserts the date that the
file was created first, and never after does it change. Is there any way
to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com