+ Reply to Thread
Results 1 to 5 of 5

Last Saved Time and Date

  1. #1
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Last Saved Time and Date

    Hello,

    Is it possible to record the last saved time in cell 'N2' ( '1:00:00 pm' format) and the last saved date in cell 'N3' ('mm/dd/yyyy' format) ?

    Thank you,
    Joe

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Last Saved Time and Date

    Enter the time in N2 and the date in N3, then save and close the workbook.

  3. #3
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Re: Last Saved Time and Date

    Dave,

    I would like this to be dynamic so each time the workbook is saved it will update those. Does this method do that?

  4. #4
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Re: Last Saved Time and Date

    Dave,

    Also this workbook will be stored in OneDrive so I would like to see when the last saved happens if another user does some changes and saves it.

    Thank you,
    Joe

  5. #5
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Re: Last Saved Time and Date

    I figured it out from other sources but thanks Dave for trying. I changed the cells but this works. In ThisWorkbook:

    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] Saved date/time not updating
    By govcam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2014, 12:36 AM
  2. Last Saved by & Time & date in cell
    By Xaos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2009, 06:27 PM
  3. Date and Time Stamp if Saved
    By Alphacsulb in forum Excel General
    Replies: 1
    Last Post: 12-13-2007, 09:46 PM
  4. last saved by with date and time
    By bdm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2007, 12:05 PM
  5. Query to find last saved date/Time
    By Dean in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2006, 04:40 AM
  6. How to have:= NOW () date/time change only if updated and saved
    By Bob Provis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. Last Saved Date and Time
    By Kim in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-15-2005, 05:05 AM

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