- Yesterday
First and Last Dates in Excel
The MIN and MAX functions are useful as for returning the first and last dates in a range. They have conditional versions as well MINIFS and MAXIFS which allow you to find the earliest and latest dates based on a condition.
Sign up to hear about free Excel training.
I won't share your email with anyone.
1 min read
They work because Excel stores dates as numbers.
In the image below we have sales in July (Australian dates) for our three products.
We can use the conditional functions to find the first and last sale date for each product.
The syntax of both functions is the same as SUMIFS.
The range to perform the calculation on is the first argument. The second argument is the first condition range, and the third argument is the first condition to look for.
Both functions can handle more than one condition.
This provides a straightforward calculation to determine first and last dates based on a condition or multiple conditions.