+ Reply to Thread
Results 1 to 7 of 7

Recording the date a cell was changed

  1. #1
    Registered User
    Join Date
    04-01-2011
    Location
    Wales
    MS-Off Ver
    Excel 2003
    Posts
    14

    Recording the date a cell was changed

    Hi Guys
    I am just wondering if there is an easy way of recording the date in say cell A2 when the value in cell A1 has been changed. Then in cell A3 calculate the number of days since the value in cell A1 was changed.
    Thanks in advance.

  2. #2
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    1,252

    Re: Recording the date a cell was changed

    Hi,

    In cell A3 put in this formula and format the cell as General:
    =IF(ISNUMBER(A2),TODAY()-A2,"")

    Then right click on the worksheet's tab > View code, paste in the below code:
    Please Login or Register  to view this content.
    Hope that helps,

    Colin

    RAD Excel Blog

  3. #3
    Registered User
    Join Date
    04-01-2011
    Location
    Wales
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Recording the date a cell was changed

    I have tried it but how do I check if it works?
    Would this also work for minutes and seconds?

  4. #4
    Registered User
    Join Date
    04-01-2011
    Location
    Wales
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Recording the date a cell was changed

    I have been playing with this have now got my head around it.
    Works perfectly.
    To take it one step further, how would I check all cells in row N for example.

    Here is the code I am using now.
    Please Login or Register  to view this content.
    Last edited by Slinky; 04-03-2011 at 09:34 AM.

  5. #5
    Registered User
    Join Date
    04-01-2011
    Location
    Wales
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Recording the date a cell was changed

    Sorry should have been row E for example.

  6. #6
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    1,252

    Re: Recording the date a cell was changed

    Hi,
    I have been playing with this have now got my head around it.
    Works perfectly.
    Good stuff. You can check if a cell was changed in column E like this:
    Please Login or Register  to view this content.
    Last edited by Colin Legg; 04-03-2011 at 09:45 AM. Reason: replies reset

  7. #7
    Registered User
    Join Date
    04-01-2011
    Location
    Wales
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Recording the date a cell was changed

    Thanks for that Colin
    Works great

+ 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