Forum Discussion
Min formula
I created a min formula to identify a dare between two set of dates however it doesn't work
2 Replies
If the dates are in A2 B2 respectively
=MIN(A2:B2)
or=MIN(A2,B2)- 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?
