Dates-Automatically entered in cells
 

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

Dates-Automatically entered in cells
 

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" 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

Dates-Automatically entered in cells
 

range("a1")=date
activecell=date
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

Dates-Automatically entered in cells
 

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

Dates-Automatically entered in cells
 

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

Dates-Automatically entered in cells
 

Thank you so much! This helped!
--
TBJohnson


"Elkar" wrote:

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" 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

Dates-Automatically entered in cells
 

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

Dates-Automatically entered in cells
 

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


Gord Dibben MS Excel MVP

On Fri, 30 Jan 2009 14:27:01 -0800, Taryn
wrote:

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!

Dates-Automatically entered in cells
 

There is actually two inbuilt function in excel to return current date
TODAY() = it returns current date
NOW()=it returns current date and time

Hope this works for you

Have a nice time

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1