Inserting current date ( TODAY() ) by inserting another character

**luci** · 08-29-2010, 06:08 AM

Hello everybody!
I am a new member on this forum, and I am interested about the way how I can insert the current date (using TODAY() ) in one cell by inserting at list one character, or a specifically type of characters (a number, in my case) into another cell. I want to create a table for monitoring and tracking production for a small production shop. Actualy I want to have a range of cells in my table where operators from different production stations can insert how many parts produced in that day, and after this in another range of cells to have automatically the current date inserted.
Thank You

**royUK** · 08-29-2010, 06:15 AM

Using TODAY() will update every day because the Function is volatile. Much better to enter the data manually. Attach an example workbook

**JBeaucaire** · 08-29-2010, 06:21 AM

As Roy has pointed out, automatic entry of dates in a cell by use of formulas would not work since the field would continue to update.

However if you're open to use of VBA and some simple macros on your sheet, it could be done. Then the dates being entered by the macros would be hardcoded dates, not formulas

**JBeaucaire** · 08-29-2010, 06:24 AM

There is a third option, you could make it easy to click on a cell and use a drop down in that cell to quickly enter today's date without having to type it. It's not automatic, but the data entry would be fast. This requires you put the formula =TODAY() in an unused cell somewhere then name that cell. Then put data validation in your date cells to use that named cell as the List Source. When you click on the cell it will present today's date as a clickable selection, and once entered would stay there until you changed it again.

**luci** · 08-29-2010, 06:31 AM

Yes You are right (royUK)! Today() is volatile. Then I want to have in one cel date inserted automatically, acording to insertion of a number into neighboring cell.
Can You somebady help me in this way. It does not metter how. Let's forget about TODAY() function.