Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert date automatically | Excel Discussion (Misc queries) | |||
Excel formula with date constraints | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |