Dates-Automatically entered in cells

[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

 

[Elkar]

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

 

[Don Guillett]

range("a1")=date
activecell=date

 

[John]

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

 

[Mike Rogers]

Taryn

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

Mike Rogers

 

[Taryn]

Thank you so much! This helped!
--
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,

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

 

[Taryn]

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

Taryn

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

Mike Rogers

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

 

[Gord Dibben]

Just don't forget that TODAY() and NOW() will update tomorrow.


Gord Dibben MS Excel MVP