Hi bal,
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,