Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1151146%22%20slang%3D%22en-US%22%3EIs%20there%20a%20formula%20other%20than%20NOW%20or%20Today%20to%20Return%20the%20Date%20the%20Workbook%20was%20last%20Modified%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151146%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20relatively%20simple%20set%20of%20Workbooks%20that%20reference%20the%20worksheets%20within%20it%20and%20I%20don't%20want%20to%20have%20to%20manually%20go%20to%20the%20overview%20Worksheet%20every%20time%20and%20update%20the%20Current%20through%20or%20As%20of%20date.%26nbsp%3B%20These%20worksheets%20are%20involving%20some%20simple%20private%20loans%20and%20they%20calculate%20the%20interest%20on%20a%20monthly%20basis%20but%20are%20only%20updated%20about%20once%20a%20month.%26nbsp%3B%20%26nbsp%3BI%20want%20the%20field%20(C3)%20in%20attached%20example%20to%20be%20the%20date%20of%20the%20last%20time%20that%20the%20Worksheet%20was%20Modified%20not%20the%20last%20time%20it%20was%20accessed.%26nbsp%3B%20Is%20there%20a%20simple%20formula%20to%20accomplish%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1151146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1151157%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20formula%20other%20than%20NOW%20or%20Today%20to%20Return%20the%20Date%20the%20Workbook%20was%20last%20Modified%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151157%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377307%22%20target%3D%22_blank%22%3E%40RMP_AZ%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20the%20following%20would%20be%20helpful%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.rowshare.com%2Fblog%2Ftips%2Fdisplaying-last-modification-time-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.rowshare.com%2Fblog%2Ftips%2Fdisplaying-last-modification-time-in-excel%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1151193%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20formula%20other%20than%20NOW%20or%20Today%20to%20Return%20the%20Date%20the%20Workbook%20was%20last%20Modified%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151193%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20Doesn't%20look%20so%20simple%2C%20but%20I%20will%20definitely%20see%20if%20I%20can%20make%20it%20work%20and%20appreciate%20your%20assistance!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1164193%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20formula%20other%20than%20NOW%20or%20Today%20to%20Return%20the%20Date%20the%20Workbook%20was%20last%20Modified%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1164193%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377307%22%20target%3D%22_blank%22%3E%40RMP_AZ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20pleasure!%20Please%20let%20me%20know%20if%20you%20need%20further%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

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

Highlighted

@RMP_AZ 

 

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