Can Excel automatically insert current date in a cell? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
AdrianXing 5/4/2005 10:55 AM PST
  Question
  Does anyone know of a function that can make Excel automatically insert the
current date into a cell when a file is opened up?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Paul B 5/4/2005 11:11 AM PST
  Answer
  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" <AdrianXing@discussions.microsoft.com> wrote in message
news:5F26601D-A0A5-468F-817F-1D58A4FDB9C2@microsoft.com...
> Does anyone know of a function that can make Excel automatically insert
> the
> current date into a cell when a file is opened up?


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
SGfla 6/30/2008 9:01 AM PST
   
  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" <AdrianXing@discussions.microsoft.com> wrote in message
> news:5F26601D-A0A5-468F-817F-1D58A4FDB9C2@microsoft.com...
> > Does anyone know of a function that can make Excel automatically insert
> > the
> > current date into a cell when a file is opened up?
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Paul D. Simon 7/1/2008 6:16 AM PST
   
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
SGfla 7/1/2008 11:23 AM PST
   
  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.
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Curt 3/7/2009 11:01 AM PST
   
  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.
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
aspect30 3/6/2009 9:07 AM PST
   
  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" <AdrianXing@discussions.microsoft.com> wrote in message
> news:5F26601D-A0A5-468F-817F-1D58A4FDB9C2@microsoft.com...
> > Does anyone know of a function that can make Excel automatically insert
> > the
> > current date into a cell when a file is opened up?
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Susan 3/6/2009 10:26 AM PST
   
  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 <aspec...@discussions.microsoft.com>
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.
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Rick Rothstein 3/6/2009 11:30 AM PST
   
  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" <aspect30@discussions.microsoft.com> wrote in message
news:AF5F11F6-12C8-4A22-9807-3B6BF825AEFF@microsoft.com...
> 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" <AdrianXing@discussions.microsoft.com> wrote in message
>> news:5F26601D-A0A5-468F-817F-1D58A4FDB9C2@microsoft.com...
>> > Does anyone know of a function that can make Excel automatically insert
>> > the
>> > current date into a cell when a file is opened up?
>>
>>
>>

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
MikeW 3/14/2009 10:42 AM PST
   
  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" <aspect30@discussions.microsoft.com> wrote in message
> news:AF5F11F6-12C8-4A22-9807-3B6BF825AEFF@microsoft.com...
> > 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" <AdrianXing@discussions.microsoft.com> wrote in message
> >> news:5F26601D-A0A5-468F-817F-1D58A4FDB9C2@microsoft.com...
> >> > Does anyone know of a function that can make Excel automatically insert
> >> > the
> >> > current date into a cell when a file is opened up?
> >>
> >>
> >>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Gord Dibben 3/14/2009 12:09 PM PST
   
  Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Columns("A:A")) Is Nothing Then
Target.Offset(0, 1).Value = Format(Now, "mm dd yyyy h:mm:ss")
End If
End Sub

This is sheet event code.

Right-click on the sheet tab and "View Code"

Copy/paste into that module.

Alt + q to return to the Excel window.

Enter something in a cell in column A and a static date/time will be entered
in column B


Gord Dibben MS Excel MVP

On Sat, 14 Mar 2009 10:43:03 -0700, MikeW <MikeW@discussions.microsoft.com>
wrote:

>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" <aspect30@discussions.microsoft.com> wrote in message
>> news:AF5F11F6-12C8-4A22-9807-3B6BF825AEFF@microsoft.com...
>> > 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" <AdrianXing@discussions.microsoft.com> wrote in message
>> >> news:5F26601D-A0A5-468F-817F-1D58A4FDB9C2@microsoft.com...
>> >> > Does anyone know of a function that can make Excel automatically insert
>> >> > the
>> >> > current date into a cell when a file is opened up?
>> >>
>> >>
>> >>
>>
>>

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Michael.Tarnowski 3/15/2009 10:08 AM PST
   
  On Mar 6, 8:26 pm, "Rick Rothstein"
<rick.newsNO.S...@NO.SPAMverizon.net> 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" <aspec...@discussions.microsoft.com> wrote in message
>
> news:AF5F11F6-12C8-4A22-9807-3B6BF825AEFF@microsoft.com...
>
> > 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" <AdrianX...@discussions.microsoft.com> wrote in message
> >>news:5F26601D-A0A5-468F-817F-1D58A4FDB9C2@microsoft.com...
> >> > Does anyone know of a function that can make Excel automatically insert
> >> > the
> >> > current date into a cell when a file is opened up?

Hi Paul,
to implement a correct time-stamp mechanism it is sometimes necessary
to "rebuild" the time-stamping formula; have a look at
http://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/b0dd2e626011e2d7/f1b447a790090855?hl=en&q=#f1b447a790090855
Cheers Michael
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
RendaBay 7/8/2009 8:27 AM PST
   
  I know VERY LITTLE about using Excel -- just learning -- so trial and error
is my only option. I have Excel X for Mac (a slightly older version). I want
to cause the date inside one of the cells to change automatically when I
open. I tried adding =TODAY() directly into the cell, but it only prints with
those same characters in the document. It doesn't show a date. I went into
"View Code" to try adding it there, but there is already stuff in the window.
I don't really understand how to do this. Can you help me?

"AdrianXing" wrote:

> Does anyone know of a function that can make Excel automatically insert the
> current date into a cell when a file is opened up?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Bernie Deitrick 7/8/2009 9:07 AM PST
   
  RendaBay,

> I tried adding =TODAY() directly into the cell, but it only prints with
those same characters in the document. It doesn't show a date.

Format that cell as General or with the specific date format that you prefer, then re-enter the
formula. The cell was formatted as text, which disables formulas just for that cell....

HTH,
Bernie
MS Excel MVP


"RendaBay" <RendaBay@discussions.microsoft.com> wrote in message
news:2E6ED582-CBB3-470B-ABB9-F7FB8BA6A47B@microsoft.com...
>I know VERY LITTLE about using Excel -- just learning -- so trial and error
> is my only option. I have Excel X for Mac (a slightly older version). I want
> to cause the date inside one of the cells to change automatically when I
> open. I tried adding =TODAY() directly into the cell, but it only prints with
> those same characters in the document. It doesn't show a date. I went into
> "View Code" to try adding it there, but there is already stuff in the window.
> I don't really understand how to do this. Can you help me?
>
> "AdrianXing" wrote:
>
>> Does anyone know of a function that can make Excel automatically insert the
>> current date into a cell when a file is opened up?


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies