I have a link to show the file names in a file folder, but I would also like to pull the date modified along with it. I currently have:
P:\14 Day\ATLDO\*
Define Name> FileNameList = FILES(SHEET1!$E$2) which is above
In cell E4 I have the list of files using:
=IFERROR(INDEX(FileNameList,Row()-3),"")
I'm not sure if I can change the function at all to get the date modified or if there is another function I can use to pull the corresponding date modified, any help would be appreciated.
Bookmarks