Excel Find Earliest Date and Latest Date

We have a range of dates and we want to look up the earliest and the latest date based on certain criteria like the earliest date for a showing movie, we can use MIN and MAX functions with IF function or INDEX function together to find the matched date based on some criteria......

#########
#########

[sajidsadiq]

Thanks, you have explained very short and easy method.