Excel Forum
Similar Content
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...



Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria


See Mr Excel and excelisfun find the record with the earliest date given three criteria. See Filter and Sort, an array formula that uses the MIN and IF functions, Advanced Filter and the best solution amongst them all the DMIN function.!
Find Earliest Date From List Of Dates Given 2 Criteria Filter or Formula





Got a Question? Ask it Here in the Forum.