Hi all,

Is there a formula that will update the date in one cell, based on when the file contained in a hyperlink in another cell is update?

Let me explain:

Column A has hyperlinks to other spreadsheets (or other files)
Column B has dates - i.e. Column name is "updated as of"

Is there a formula I can insert in Column B that would automatically update the date as a function of when the latest modification takes place to the sheet in column A??

Thank you all for you help!!