I want to write a date to a specific cell

Microsoft Excel 2003 (full product)
November 3, 2010 at 12:25:50
Specs: Windows XP
I have a list of unique numbers. I also have a formula (or function) that when a number is entered in a specified cell, the list is searched and the address of the cell adjacent to the one containing the number is returned. For instance, if 12345 is entered and it is in cell A649, then $B$649 is returned. I want to write today() in that cell. How do I do it?

See More: I want to write a date to a specific cell

Report •

November 3, 2010 at 20:28:26
You want to replace whatever is in B649 with =TODAY()?


Are you aware that =TODAY() is Volatile and will update every time the sheet calculates, including every time you open and close the workbook?

In other words, what is displayed in B649 today will be different tomorrow, and the next day, and the next, etc.

In addition, put enough =TODAY()'s in your spreadsheet and you'll slow it down since they will all recalculate at the same time, every time.

That said:

1 - You can't place a value in a cell with an Excel function. An Excel function can only return a value in the cell in which it resides.

If you want to place a value (or function) in a cell via some "automatic" method, you'll need to use VBA.

2 - How are you returning a cell address? Can I assume you are already using VBA, perhaps a UDF?

Report •

November 8, 2010 at 04:47:44
Your presumption that I am using VBA aside, the method I am using to return the address of the cell adjacent to the one requested is rather simple, really: =ADDRESS(MATCH(F2,A1:A26,0),MATCH("DATE",A1:B1,0)).

No cells would contain the expression =TODAY() as that would certainly cause the condition you wrote in your reply. I used that only to illustrate that I wanted the current date written to the cell.

Thank you for you very instructive and informative response, but I too have discovered that Excel does not provide a method of writing a value to a cell. Therefore, as you so diligently noted, I would have to use VBA.

However, because of the complexity of my application and the inherent shortcomings of Excel, I have decided to use Access.

Report •

Related Solutions

Ask Question