Latest Date Formula

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

Find more posts tagged with

Formulas

Accepted answers

L_123

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.