A formula can do that, but it will change to whatever day it is when you
open the workbook. Otherwise you will most likely need to use VB.

=NOW()
Format the cell as needed.


"Dr Fleau" wrote in message
news:iay5f.20337$y_1.5006@edtnps89...
Hi y'alls, noob here.

I want certain Excel spread sheets (Quote and order forms) to insert the
current date in a certain cell at the file's opening. How can I do that,
if
possible, avoiding any form of VBA. I get itches just thinking of VB.

Thanx a bunch

Pete