Find LAST Date Based on Criteria | Excel MAXIFS Function

preview_player
Показать описание
Find the last date based on criteria in Excel using the MAXIFS function.

Finding the last date for specific criteria sounds like an awkward task, but the formula is actually very simple. This is because of the MAXIFS function in Excel.

*** Online Excel Courses ***

Connect with us!

#excelshorts #excelformulas #advancedexcelformulas
Рекомендации по теме
Комментарии
Автор

U can also use lookup function btw great trick.

souvikdas
Автор

This is super cool, but for some reason it’s giving me back a weird date like 1/0/1900. Any thoughts?

ngee
Автор

this is good for Dates. But if like last money spent of the team.

princejoe