+ Reply to Thread
Results 1 to 7 of 7

freeze the date so it will not update everyday

  1. #1
    Registered User
    Join Date
    07-14-2011
    Location
    Porcodio
    MS-Off Ver
    Excel 2003
    Posts
    1

    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!!

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    Belgium
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,198

    Re: freeze the date so it will not update everyday

    Hi and welcome to the board

    Try http://www.techrepublic.com/article/...sheets/6025056
    Google has lots of answers to this problem
    Quoting entire posts clutters the forum and makes threads hard to read !

  3. #3
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: freeze the date so it will not update everyday

    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

  4. #4
    Registered User
    Join Date
    04-19-2012
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: freeze the date so it will not update everyday

    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!

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,205

    Re: freeze the date so it will not update everyday

    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.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: freeze the date so it will not update everyday

    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.

  7. #7
    Registered User
    Join Date
    04-19-2012
    Location
    Zagreb, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Thumbs up Re: freeze the date so it will not update everyday

    Quote Originally Posted by royUK View Post
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1