Dates-Automatically entered in cells

  • Thread starter Thread starter Taryn
  • Start date Start date
T

Taryn

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
 
You could use =TODAY() for the current date. Or =NOW() for current date and
time. Note that these formulas will update whenever the worksheet is
recalculated.

HTH
Elkar
 
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

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

Mike Rogers
 
Thank you so much! This helped!
--
TBJohnson


Elkar said:
You could use =TODAY() for the current date. Or =NOW() for current date and
time. Note that these formulas will update whenever the worksheet is
recalculated.

HTH
Elkar


Taryn said:
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
Click to expand...
Click to expand...
 
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 said:
Taryn

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

Mike Rogers

Taryn said:
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
Click to expand...
Click to expand...
 
Just don't forget that TODAY() and NOW() will update tomorrow.


Gord Dibben MS Excel MVP
 
Back
Top