Return latest date in a range
This tutorial shows how to get the latest date in a range using Excel formulas, with the MAX and LARGE functions
|
=MAX(B5:B9)
|
GENERIC FORMULA
=MAX(range)
ARGUMENTS EXPLANATION This formula uses the MAX function which returns the largest number from the selected range to find the latest date. When a date is formatted as a number the latest date will have the highest value, therefore, the MAX function is appropriate to use for this example.
In this example the cell B8, with a date of 8 April 2020, contains the latest date from the selected range (B5:B9). |
|
=LARGE(B5:B9,1)
|
GENERIC FORMULA
=LARGE(range,1)
ARGUMENTS EXPLANATION This formula uses the LARGE function, with the nth largest value set to 1, which will return the largest number from the selected range to find the latest date. When a date is formatted as a number the latest date will have the highest value, therefore, the LARGE function is appropriate to use for this example.
In this example the cell B8, with a date of 8 April 2020, contains the latest date from the selected range (B5:B9). |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Return largest number with criteria | How to get the largest number from a list with a specific criteria | |
| Return earliest date in a range | How to get the earliest date in a range |
RELATED FUNCTIONS
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| LARGE Function | The Excel LARGE function returns the numeric value from a specified range based on the nth largest position | |
| MAX Function | The Excel MAX function returns the largest value from a specified range of numeric values |