I have not been able to compare dates with the above formula. Is there a catch?
You need to provide more info. Do you get any error message? What is your LibreOffice version and operating system name/version? How did you input date data in which format - write sample of how you typed in date. What is your language settings? Tools | Options | Language Settings | Languages | Locale settings?
No error message, just doesn’t give the correct response. Ubuntu. Libreoffice 4.0.22. I entered dates in two cells (A1,A2). In cell A3 I entered the formula =if(A1>=A2,1,0). The answer is the same no matter what the dates are (if A1> or if A2>).
Above formula should work just fine. Check to see if you have correct format cell defined for dates fields. Select both cells - right click on them - Format Cells - Category = Date. The cell where the formula is check that format cell is defined as Number.
Will this work if one of the date cells is a function (=today()?
Yes. .