Return First or Last Date (Earliest or Most Recent) Excel Formula | Based on Multiple Criteria

In this video I demonstrate how to lookup and return the earliest or most recent date . To do this without criteria use the MIN or MAX functions. To achieve this using single or multiple criteria use the MAXIFS function.

Table of Contents:

00:00 - Introduction
00:17 - Return the earliest or most recent date using MAX and MIN
02:58 - Return the earliest or most recent date based on a single or multiple criteria using MAXIFS
05:47 - Using Excel tables
------------------------

[jennifermason]

Thank you! I have been trying to work this out. This just made a complex report where I have to strip out duplicates much easier!

[tinplategeektoo]

Thank you for covering the part of using Table and Column names to attempt to future proof the formula .

[IvanCortinas_ES]

Another great tutorial. Thank you Chester!

[wayneedmondson]

Great lesson Chester! Thanks and thumbs up!!

[alexandrkrav]

Chester, thank you. I been searching some solution with help of this function, which perfectly explained in your video. Thank you. Alexander K.

[arbazahmad]

Great 👍. U can use whole criteria rather than selecting one criteria and drag . It will give spill range...

[ggoliver]

Loved it. Thank you for making the time to be clear and such a simple way of getting what i needed without overcomplicating it! I appreciate you.

[ChrisInTheNorth]

My criteria in the date! I have a list of dates and I want to find the minimum date that is after a given date (which is stored in a different cell

[nickmcgill]

I have a dataset for a car rental company and I am trying to find the number of months that each vehicle has been in service. I want to find the min month to see it's first month in service and the max month to find the last month it was in service and then find the total number of months based upon those two columns. I can't for the life of me figure out how to get just the month to show up instead of an entire date. I just want 1, 2, 3 etc for min and 10, 9, 8 etc for max. Would you have any suggestions?

[mrspongetv]

Hi sir. Can you help me? What i wanted in my ghant chart is that when i add a holiday, all activities will adjust even if the other activities did not fall onto the holiday date.. can it be possible?? Love the video by the way.

[marksibert]

I found this useful for past dates, but now I need to know how to find the closest date to today, when you have a bunch of dates in the past and future? Let's say you have a list of events but only need to know the one that's a week away from now.

[gvalverde]

I actually need the opposite of this. Return top three items of most recent date. Can you refer me to a relavant vid?

[nathanmoses]

Do you have any idea why the min and max functions are not working for me. I have a list of 2000 dates in the month of December. All I want to do is return the earliest and the latest dates from the range. I try using =min(g18:g2000) and =max(g18:g2000). For both these functions I just get back 1/0/00. If I convert it to a number it is just zero. Why doesn't it return the minimum and maximum dates?