+ Reply to Thread
Results 1 to 5 of 5

Is there a way to show Cell Date last updated?

  1. #1
    Registered User
    Join Date
    10-03-2022
    Location
    Dallas
    MS-Off Ver
    Microsoft 365
    Posts
    56

    Is there a way to show Cell Date last updated?

    Hey Everyone,

    I am trying to research if there is a way to get excel to show the date last updated for B2 on C2 in the example below. All I keep finding are VBA examples. Is there any other way I can do this or is it only VBA?

    Example pic.JPG

    Example.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Is there a way t show Cell Date last updated?

    The only reliable way involves VBA. This approach is a bit flawed.

    Delete the values in B.

    =IF(B2="","",IF(C2="",NOW(),C2))

    (for the moment, use NOW, not TODAY... for obvious reasons).

    File/Options/Formulas/Enable iterative calculations.

    add values to B. The date/timestamp appears.

    Overtype one of the values in B. Nothing happens (the flaw).

    DELETE one of the values in B and re-enter another. The datestamp reappears, with the correct time.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,858

    Re: Is there a way to show Cell Date last updated?

    IMO, VBA is the easiest way -- especially when you are looking for "date/time last updated"

    If you are going to succeed at a worksheet formula only approach to this, I expect you will start with this tutorial (https://chandoo.org/wp/timestamps-excel-formula-help/ ) which shows how to do a "date/time first entered" type of timestamp. The problem I have always had is that "date/time last updated" is much more difficult logic to capture in a nested IF() formula. By contrast, a VBA change event naturally traps the cell that was edited, so it is easy to determine which cell was edited, and you can then easily write a date stamp to the spreadsheet when certain cells are edited.

    Look over Chandoo's tutorial and see if you can at least make that work comfortably. Then you can see if you can figure out the correct logic to include in a similar formula to get your timestamp to behave the way you want.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    10-03-2022
    Location
    Dallas
    MS-Off Ver
    Microsoft 365
    Posts
    56

    Re: Is there a way to show Cell Date last updated?

    Yeah it looks like the best way to go is VBA, Thank you both.

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,490

    Re: Is there a way to show Cell Date last updated?

    VBA Code Drop Activity Sheet

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code to show when a cell was updated, for several columns
    By gjjh25 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-15-2022, 08:54 PM
  2. Show "last updated on: (date)" when changes in row/column are made
    By dennisvc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2014, 08:53 PM
  3. Replies: 5
    Last Post: 12-06-2013, 08:22 AM
  4. Macro to append a date to an existing cell if date is updated
    By brigitteMogg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2013, 10:04 AM
  5. Replies: 0
    Last Post: 06-20-2012, 10:58 AM
  6. Last Updated Date & time in Cell
    By excelkeechak in forum Excel General
    Replies: 8
    Last Post: 01-10-2010, 05:01 PM
  7. Date Cell last updated
    By Sparrow in forum Excel General
    Replies: 5
    Last Post: 11-22-2006, 05:44 PM

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