I have two cells in OpenOffice Calc (A1 and B1). In cell A1, I have "2014/01/01" and in cell B1, I have "2014/06/03". I want to find the minimum/smallest of the values in A1 and B1. I actually have hundreds of values in column A and column B and I want to populate column C with the smallest of the two dates in column A and B.
I tried entering the following into column C1:
=MIN(A1,B1)
which I thought would produce "2014/01/01", but instead it initially produced "0". I then tried right-clicking on cell C1 and I did format cell and changed the format to "Date" which then produced "12/30/99" which is also incorrect.
I've tried googling on this question, but I haven't been able to figure out why the MIN function doesn't work with dates. Is there a different open office function that I should be using to find the smallest of two dates? Or something wrong with my MIN expression?