From the File menu, go to Header/Footer. Click on the footer tab, and the code for inserting the date/time is $D.

Here are the codes that you can use in the Header/Footer sections:

APP NAME: $A
SHEET TAB NAME: $R
DATE: $D
FILE NAME: $F
PAGE #: $P
# OF PAGES: $N

Regards,