Calculate the earliest or latest date in Excel based on criteria by Chris Menard

preview_player
Показать описание
If you have dates in Excel, and you want to find the earlies or lastest date based on a criteria, use the MAX or MIN function with the IF function. The formula will need to be entered as an array function

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Рекомендации по теме
Комментарии
Автор

What if the key word is not there how do i avoid the result being 00/01/1900?

khushwantdigpal
Автор

Thanks for the video. I would like to expand on it a little to solve a problem. Is it possible to return the last value if meeting 2 criteria?

rfrost
Автор

Thank you Sir.
You have saved my week. Now I can complete week task in an hour.

ajaykushwaha
Автор

Thanks a ton, it really helps me to find the latest date in rows of database

mohansawant
Автор

you're a hero. this is awesome. saved me hours and hours of work. Thanks

AidanSkoyles
Автор

The amount of times this video has saved my next!!

anne-marieolivier
Автор

This is just what i needed thank you. But i did realize thta you must be the $ in your formula otherwise when you drag the formula it will not populate the correct date. Just wanted to share because you don't always need that and i don't usually use the Max formula so i didn't know.

dinabianco
Автор

Yeee it worked precisely to my working projects. This particular lesson has made my project looked genius 🙏 🤙 😁 👏

dinog.
Автор

I was looking for exactly this! Thanks so much Chris.

rachitkalani
Автор

For anyone has problem about their date format, ex : 1/0/1900, press "Shift+Enter" when entering the formula instead just "Enter". It's because we are using the array function

trexarsgo
Автор

Thanks for the trick, But Why are the cells showing zero after closing the file and open it again until re enter control shift enter in each cells? Please advise

gentlemen
Автор

Thanks for the video!

Edit - just figured out my solution - Using MAXIFS

does this work with with AND? I'm having trouble getting it to work
ie MAX(IF(AND(Logic 1, Logic 2), Date Range)

jobber
Автор

Very useful formula👍🏻, helped me saving lot of time.

rajasnkl
Автор

Hi this is great but i have a query..

If we wish to find the 2nd highest value for a specific company then how do we calculate?

parshad
Автор

This is way simpler than everything I was trying, thank you for posting@😁

kevinlawrence
Автор

Thanks, this saved my day in the office today.

senciddimisin
Автор

Chris, if you had a list of data like this date person reading
1-May-20 George Kline 560
15-May-20 car radio 1043
13-Jun-19 firm lawyer 890
30-Jun-19 bill debasher 356
1-Jan-21 Denton voles 87
15-Jan-21 Mitch mcdere 900
16-Jan-21 car radio 235
6-May-20 George Kline 764
28-Jun-19 firm lawyer 809
11-Jun-20 bill debasher 445
14-Jan-21 Denton voles 434
24-Jan-21 Mitch mcdere 876


How do I use a formula to output the difference in dates for a specific person with the readings on a separate tab in excel. Such as these columns:
may readings June readings July readings

Any help would be appreciated.

mdaje
Автор

Thank so much for this simple way to share this.. I have subscribed you for more these types of videos to improve my skill.

Chirag
Автор

Thank you so much, this is what i am exactly looking for, you save my time

zameerzmr
Автор

Hello Chris,
Let say there few columns before the invoice date column, which quantity, item, etc and the end invoice date What is the formula to return the last date.

quincyirang