Getting Date Modified

[KlayColgrove]

I have a list of files that are lined up using D:\Documents\* with the function =IFERROR(INDEX(FileNameList,ROW()-2),""). With this it lists all the files in my D drive. I'm trying to also display the date last modified of those files in the corresponding cell. Is that possible to do?

 

[sandy666]

You can do that in easy way with PowerQuery (Get&Transform) with FromFolder option:

example:

Name	Date modified
s666-PQ-How to split cells that have Line Feed into their own row.xlsm	14/05/2019 05:04​
s666-PQ-excel help.xlsx	14/05/2019 02:18​
test-14052019.xlsm	14/05/2019 02:17​
s666-PQ-Append tables and get unique values.xlsm	12/05/2019 07:03​
s666-PQ-split addresses.xlsm	11/05/2019 21:07​
Replace Values from a List.xlsx	11/05/2019 17:23​
delete_book.xlsm	11/05/2019 15:09​
s666-PQ-FL Workbook V2.xlsx	10/05/2019 09:08​
delete-Book1.1.xlsm	10/05/2019 05:17​
delete-Book1.xlsm	08/05/2019 22:03​
s666-PQ-looking companies for person.xlsm	08/05/2019 06:44​
s666-PQ-avoid error of Split Column.xlsm	07/05/2019 00:19​
s666-PQ-fxTextSplitN.xlsm	06/05/2019 11:36​
vba-urls from site.xlsm	06/05/2019 01:31​
s666-PQ-room utilization and empty slots.xlsm	05/05/2019 04:28​
test_10042019_1715.xlsm	29/04/2019 01:52​
PQ-Number Grouped Rows.xlsx	28/04/2019 07:37​
Book1.xlsm	28/04/2019 07:29​
s666-PQ-how much sold in hour.xlsm	27/04/2019 23:33​
s666-PQ-TFR base, removed blank columns.xlsm	26/04/2019 21:10​
s666-PQ-Sort TableFromRecords.xlsm	26/04/2019 02:23​
s666-PQ-Not purchased.xlsm	25/04/2019 15:41​
test_17042019_1904.xlsm	21/04/2019 20:05​
sections.xlsm	19/04/2019 02:32​
multiple.xlsm	17/04/2019 19:49​
s666-PQ-Calendar.xlsm	14/04/2019 01:54​

[SIZE=1]let
    Source = Folder.Files("[B][COLOR="#FF0000"]D:\your_path[/COLOR][/B]"),
    #"Removed Columns" = Table.RemoveColumns(Source,{"Content", "Extension", "Date accessed", "Date created", "Attributes", "Folder Path"}),
    #"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Date modified", Order.Descending}})
in
    #"Sorted Rows"[/SIZE]

You can sort by date in ascending or descending order (here is descending)

is that something what you want?