Min formula

Copper Contributor
I created a min formula to identify a dare between two set of dates however it doesn't work
2 Replies
really need more info to help you. ideally a sample sheet (without private info). But first thing I would check is that the 2 dates are in fact dates and not text. What happens if you change the format from short to long date, does it change? what if you subtract the 2 dates?

If the dates are in A2 B2 respectively

=MIN(A2:B2)


or

=MIN(A2,B2)