freeze the date so it will not update everyday

Hello, please help me out with this one.

So I am at work workin on this report and I need a function that will make Excel automatically insert the today's date in a cell (let's say D90) when I fill the content of another cell (for example C90) and the that will be inserted will never change. I tried to use the =TODAY( ) function but it keeps updating the date in the cell to the current date if i reopen the worksheet 2 days later. I need the cell to keep in the cell the date of the day when I filled in the content of cell C90 and do not updated it every time i open the document to the actual date.. Thanks in advance!!

Hi and welcome to the board

Try http://www.techrepublic.com/article/...sheets/6025056
Google has lots of answers to this problem

try this in your worksheet

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("C90")) Is Nothing Then
Cells(Target.Row, 4) = Date
End If
End Sub

Hello to all,

As for being new to the forum, first I'll say hi and then explain my problem, so: hi.

I have a very familiar problem, but only my includes the action of filling multiple cells with the date only the day the change has been made, without updating each day. So in example:
Cells B2:B16 need to contain today's date: 19.4.2012. from the moment i write 19.4.2012 in B2, the cells automatically obtain the date, and it does not update depending on the PC's date.

Thanks in advance!

What I have done to overcome this problem is to record a macro, select the cell first then start recording macro - write in " =now() " and format the cell so it looks how you want it. Copy the cell and then paste values - stop recording.
Now you can run this macro in any cell. If you keep a " Book of Macros " seperate with your macros stored here then when it is open you can run the macros in any workbook you are using.

Originally Posted by royUK

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Sorry 'bout that one there...will make a new thread, what I thought is that these two problems are closely related so I don't make yet another thread regarding almost the same issue