DH Templates

In Excel, how do you make the current date show up in a certain spot each time you open that workbook?

We have a certain invoice template that always used to put the current date on the page, but had to change it once, and ever since, I've had to type in the date instead of it automatically putting it there. HELP!

Public Comments

1. =NOW() and format the cell as a date.
2. Select the cell and go to Insert -> Function then select All from the combo box and type "Today" in the top field, then click on Go Finally select "Today" from the list and click OK. You're done! Good Luck!