Forum Discussion

RMP_AZ's avatar
RMP_AZ
Copper Contributor
Feb 04, 2020

Is there a formula other than NOW or Today to Return the Date the Workbook was last Modified?

I have a relatively simple set of Workbooks that reference the worksheets within it and I don't want to have to manually go to the overview Worksheet every time and update the Current through or As of date.  These worksheets are involving some simple private loans and they calculate the interest on a monthly basis but are only updated about once a month.   I want the field (C3) in attached example to be the date of the last time that the Worksheet was Modified not the last time it was accessed.  Is there a simple formula to accomplish this?

3 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor

    Hello RMP_AZ,

     

    Maybe the following would be helpful:

    https://www.rowshare.com/blog/tips/displaying-last-modification-time-in-excel/

    • RMP_AZ's avatar
      RMP_AZ
      Copper Contributor

      Thank you! Doesn't look so simple, but I will definitely see if I can make it work and appreciate your assistance! PReagan

      • PReagan's avatar
        PReagan
        Bronze Contributor

        RMP_AZ 

         

        My pleasure! Please let me know if you need further assistance.

Resources