Latest Date Formula

Cheryl Collins

Hi

I want to find the latest date a review was done on a file number. Multiple reviews could have been done on the same file so, I only want the latest date. I have used:

=INDEX(MAX({01.SHEET: File Review Range 1}, MATCH([Matter Number]@row, {01.SHEET: File Review Range 2})), 0)

as I am referencing the File Review sheet but it comes back with an #INVALID DATE, I'm assuming it's because I've got my MAX in the wrong place, or I can't use MAX in my nested formula. Any ideas?

TIA

Cheryl

L_123

=max(collect({01.SHEET: File Review Range 1},{01.SHEET: File Review Range 2},[Matter Number]@row

L_123

=max(collect({01.SHEET: File Review Range 1},{01.SHEET: File Review Range 2},[Matter Number]@row

Cheryl Collins

Perfect, thanks @L_123