Hi Taryn
For a Volatile date, will change everyday type =Today() or =NOW() will give
you date and time but can be formatted just has date.
To have a static date, will not change everyday, you to press Ctrl key and :
for time press Ctrl Shift and same botton.
You could have a macro that will do that also.
HTH
John
"Taryn" wrote in message
...
Hi,

Is there a function to automatically enter the current, real-time date in
a
cell? I'm looking for a function similar to what is used in the header
and
footer section of a workbook that allows the footer to be customized and
to
insert on a page the date. The function,if this is the correct term to
use,
shows up as &[Date] in the footer or header. Is there something that I
can
set-up maybe a macro, in a designated column to automatically be
displayed
in a cell?
-- Thanks
TBJohnson