Thanks. I did try what you suggested, but I needed this to happen
automatically. So using what John,Don &Elkar suggested above was what I was
looking for. Thank for posting a reply to my question Mike!
--
TBJohnson


"Mike Rogers" wrote:

Taryn

Tap Control and Semi colon for date
Tap Shift and control and Semi colon for time

Mike Rogers

"Taryn" wrote:

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