how to get recent 6 dates (Max dates)

find most recent date for id with multiple records in excel sheet
how to find the latest date in excel based on criteria
lookup a value and find max date in excel
vlookup latest date
find max date in excel with criteria
vlookup(max date)
find latest date in excel
index match(max date)