Last modified date of one workbook into another workbook's worksheet

[Kemidan2014]

I did some googling and i saw plenty of references for displayling the last date modified or saved of the ACTIVE excel file but what if i want to display the last modified date of another workbook?

We have a master sheet that we download information which is a non-macro enabled workbook. its just raw data but we save it as the same file name and in the directory everytime we update it

The work book we use to filter the data from there References this master sheet so i wanted to show a date in one of the sheets to show when the last time the MASTER file was modified or saved so we the user can see how old the data is.