A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can Excel automatically insert current date in a cell?



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2005, 06:56 PM
AdrianXing
external usenet poster
 
Posts: n/a
Default Can Excel automatically insert current date in a cell?

Does anyone know of a function that can make Excel automatically insert the
current date into a cell when a file is opened up?
  #2  
Old May 4th, 2005, 07:08 PM
Paul B
external usenet poster
 
Posts: n/a
Default

AdrianXing, you could put =TODAY() in a cell and it will up date, if you
don't want the date to change after you put it in use some code in the
workbook open event to do it, like this

Sheets("Sheet1").Range("A1") = Date

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"AdrianXing" wrote in message
...
Does anyone know of a function that can make Excel automatically insert
the
current date into a cell when a file is opened up?



  #3  
Old June 30th, 2008, 05:02 PM posted to microsoft.public.excel.worksheet.functions
SGfla
external usenet poster
 
Posts: 8
Default Can Excel automatically insert current date in a cell?

PaulB (or anyone) - I have a question about inserting a current date into a
spreadsheet, but I don't want the date to change once I've saved it, closed
it and reopened it on a different date. Can you explain the formula to
insert the current date in a cell (or range of cells) and once you save, that
date stays, but the next day enters that current date?

"Paul B" wrote:

AdrianXing, you could put =TODAY() in a cell and it will up date, if you
don't want the date to change after you put it in use some code in the
workbook open event to do it, like this

Sheets("Sheet1").Range("A1") = Date

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"AdrianXing" wrote in message
...
Does anyone know of a function that can make Excel automatically insert
the
current date into a cell when a file is opened up?




  #4  
Old July 1st, 2008, 02:11 PM posted to microsoft.public.excel.worksheet.functions
Paul D. Simon
external usenet poster
 
Posts: 23
Default Can Excel automatically insert current date in a cell?

While neither a formula solution nor an automated method, simply doing
Ctrl+; (in other words, holding down the Ctrl key while hitting the
semi-colon) will enter the current date as a static (non-changing)
date into the active cell.
  #5  
Old July 1st, 2008, 07:24 PM posted to microsoft.public.excel.worksheet.functions
SGfla
external usenet poster
 
Posts: 8
Default Can Excel automatically insert current date in a cell?

Thanks, Paul D. That helps!

"Paul D. Simon" wrote:

While neither a formula solution nor an automated method, simply doing
Ctrl+; (in other words, holding down the Ctrl key while hitting the
semi-colon) will enter the current date as a static (non-changing)
date into the active cell.

  #6  
Old March 6th, 2009, 06:08 PM posted to microsoft.public.excel.worksheet.functions
aspect30
external usenet poster
 
Posts: 1
Default Can Excel automatically insert current date in a cell?

How can I make today's date auto fill in a cell upon entering data in another
cell. I would like the cell B1 that contains the date to remain empty until I
enter data in cell A1.
Please advise.
Thanks.

"Paul B" wrote:

AdrianXing, you could put =TODAY() in a cell and it will up date, if you
don't want the date to change after you put it in use some code in the
workbook open event to do it, like this

Sheets("Sheet1").Range("A1") = Date

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"AdrianXing" wrote in message
...
Does anyone know of a function that can make Excel automatically insert
the
current date into a cell when a file is opened up?




  #7  
Old March 6th, 2009, 07:23 PM posted to microsoft.public.excel.worksheet.functions
Susan
external usenet poster
 
Posts: 214
Default Can Excel automatically insert current date in a cell?

an easy way is to make cell B1 have =today() be in it, but format it
to white text.
then do conditional formatting that if
A1""
then the text changes to black and the date can be seen. that way the
date is always there, you just don't see it until you enter data into
cell A1.
hope that helps.

susan


On Mar 6, 12:08*pm, aspect30
wrote:
How can I make today's date auto fill in a cell upon entering data in another
cell. I would like the cell B1 that contains the date to remain empty until I
enter data in cell A1.
Please advise.
Thanks.

  #8  
Old March 6th, 2009, 08:26 PM posted to microsoft.public.excel.worksheet.functions
Rick Rothstein[_2_]
external usenet poster
 
Posts: 2,013
Default Can Excel automatically insert current date in a cell?

I'm assuming that once the date is added to the worksheet, you would not
want it to change. If that is the case, you will need to use VB event code
to handle this. Is a VB solution an acceptable choice?

--
Rick (MVP - Excel)


"aspect30" wrote in message
...
How can I make today's date auto fill in a cell upon entering data in
another
cell. I would like the cell B1 that contains the date to remain empty
until I
enter data in cell A1.
Please advise.
Thanks.

"Paul B" wrote:

AdrianXing, you could put =TODAY() in a cell and it will up date, if you
don't want the date to change after you put it in use some code in the
workbook open event to do it, like this

Sheets("Sheet1").Range("A1") = Date

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"AdrianXing" wrote in message
...
Does anyone know of a function that can make Excel automatically insert
the
current date into a cell when a file is opened up?





  #9  
Old March 7th, 2009, 08:02 PM posted to microsoft.public.excel.worksheet.functions
Curt
external usenet poster
 
Posts: 132
Default Can Excel automatically insert current date in a cell?

Is there a way to use only the day of the date in this manner. Trying to have
an occurance all ways on th 15th of month year after year
Thanks

"Paul D. Simon" wrote:

While neither a formula solution nor an automated method, simply doing
Ctrl+; (in other words, holding down the Ctrl key while hitting the
semi-colon) will enter the current date as a static (non-changing)
date into the active cell.

  #10  
Old March 14th, 2009, 06:43 PM posted to microsoft.public.excel.worksheet.functions
mikew
external usenet poster
 
Posts: 22
Default Can Excel automatically insert current date in a cell?

Rick, I'm trying to do the same thing, could you explain the VB event code
I'd have to use?

"Rick Rothstein" wrote:

I'm assuming that once the date is added to the worksheet, you would not
want it to change. If that is the case, you will need to use VB event code
to handle this. Is a VB solution an acceptable choice?

--
Rick (MVP - Excel)


"aspect30" wrote in message
...
How can I make today's date auto fill in a cell upon entering data in
another
cell. I would like the cell B1 that contains the date to remain empty
until I
enter data in cell A1.
Please advise.
Thanks.

"Paul B" wrote:

AdrianXing, you could put =TODAY() in a cell and it will up date, if you
don't want the date to change after you put it in use some code in the
workbook open event to do it, like this

Sheets("Sheet1").Range("A1") = Date

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"AdrianXing" wrote in message
...
Does anyone know of a function that can make Excel automatically insert
the
current date into a cell when a file is opened up?





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query for 'confirmation' rogge Running & Setting Up Queries 8 April 19th, 2005 03:26 PM
How can I get the current date to insert automatically when I se. cit General Discussion 0 March 30th, 2005 11:09 PM
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller General Discussion 1 February 8th, 2005 10:34 AM
How to insert future date based on current date plus 14 days John Bakker General Discussion 1 January 31st, 2005 10:08 PM
Aggregating Date Data into Weeks and Quarters Roger Running & Setting Up Queries 3 July 11th, 2004 05:56 PM


All times are GMT +1. The time now is 03:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.