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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920