+ Reply to Thread
Results 1 to 4 of 4

How to show last date modified

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    439

    How to show last date modified

    what would be the way to have a column return the last date another cell/same column was modified? Thanks

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,174

    Re: How to show last date modified

    How about you attached a sample workbook with what you have and what you expect.

    See "Yellow" banner
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    439
    Quote Originally Posted by jeffreybrown View Post
    How about you attached a sample workbook with what you have and what you expect.

    See "Yellow" banner
    Just like a1 always displays the last date and/or time b1 was modified.
    Excel 1.0.1 (16.0.14326.20140) (Android)
    Excel 2010 14.04.4760.1000

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,174

    Re: How to show last date modified

    You will need VBA to do this. Right click on the sheet tab and then paste the below on the right side of the screen. This will monitor B1 and when a change is made, A1 will show the date. Format A1 as a date.

    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] show last modified date of a cell
    By rachelwahid in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-17-2017, 03:31 AM
  2. show last modified date of a cell
    By rachelwahid in forum Excel General
    Replies: 2
    Last Post: 08-13-2017, 04:35 AM
  3. Show today's date if specified cell is modified
    By xavpg in forum Excel General
    Replies: 7
    Last Post: 02-28-2012, 07:16 PM
  4. Show date last time modified
    By José Manuel Soberón in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2006, 05:10 AM
  5. [SOLVED] Show date cell modified
    By manxman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2006, 07:50 PM
  6. Automatically show new date in the modified cell
    By NYBoy in forum Excel General
    Replies: 9
    Last Post: 10-04-2005, 11:55 AM
  7. show date modified in a cell
    By Lana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2005, 07:06 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