Min between 2 dates

[Mathman]

How can I get the minimum value between 2 dates?

Thank you
MM
​

 

[mikerickson]

The MIN function would work. If you have a date in A1 and another in B1, the formula =MIN(A1, B1) will return the earlier of those two dates.

 

[Mathman]

Sorry, that was badly worded on my end.

I have 10 years of dates in column A and values in column B. In C1 I have sept, 1 2018 and in C2 I have sept, 1 2017

I need to get the min value between these 2 dates.

Hope that was clearer on my part.

Thx

 

[mikerickson]

You want to find the minimum of the column B values whose column A data is between the two given dates C1 and C2.

Put this in a cell (adjust the A1:A10 reference to include all of your range) and enter it with CTRL-Shift-Enter

=MIN(IF(C1<A1:A10,IF(A1:A10<C2,B1:B10)))

 

[Joe4]

Mike,

Your formula did not come through. Remember, if you are using > or < signs, be sure to surround them with spaces so they aren't mistaken for HTML code.

 

[mikerickson]

Thanks

=MIN(IF(C1 < A1:A10, IF(A1:A10 < C2, B1:B10)))

 

[Mathman]

that's great, Thank you!