Excel - How to Calculate MIN and MAX Between 2 Dates - Duel 120 - Episode 1697

2,148 views · Published 26 April 2013 · 9:12 · Indexed 6 November 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Find Min and Max between two dates

Welcome to another exciting episode of Dueling Excel, where Mike Girvin from ExcelIsFun and I, Bill Jelen from MrExcel, go head to head to solve your Excel problems. In this episode, we tackle the challenge of finding the minimum and maximum values between two dates for each region. A viewer sent in this question on YouTube and we are here to provide the solution.

To solve this problem, I will be using the DMIN and DMAX functions, which require a criteria range to be set up with headings at the top and values just below. I will demonstrate how to build a criteria range using the greater than or equal to and less than or equal to operators, and then use the DMIN and DMAX functions to find the minimum and maximum values for the specified dates and region. However, the DMIN and DMAX functions require a large criteria range for each region, but I have a trick up my sleeve to simplify this process.

I will be using a data table to make the process more efficient. By selecting the entire range and using the Data Table feature, we can easily find the minimum and maximum values for each region without having to create a separate criteria range for each one. I will also show you how to customize the number formatting to display the words "MIN" and "MAX" instead of the actual values. But, as always, Mike has a different approach to solving this problem using the AGGREGATE function. Let's see what he has in store for us.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Min and Max Value between 2 Dates in Excel
(00:20) Using DMIN and DMAX
(01:25) Using a data table to simplify criteria range
(02:39) Alternative method using AGGREGATE function
(08:50) Another alternative method using MAX IF IF IF
(09:00) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelformula #excelformulasandfunctions #exceldates

This video answers these common search terms:
excel find min and max values between date range
finding lowest and highest values between specific dates in excel
calculate minimum and maximum values in excel between two dates
get minimum and maximum data within date range in excel
excel formula for min and max between date boundaries
min and max values in excel based on date criteria
aggregate data between two dates in excel
identify minimum and maximum values within a date range in excel
excel functions to find min and max within date interval
determine extreme values within date range in excel

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153519/

More from this channel