Question: how to calculate difference between two dates in open office?
Answer: Syntax: DAYS(t1; t2) The minus sign appears in the result because OpenOffice.org Calc always subtracts t2 from t1 (t1 – t2). Remember that you can remove the minus sign with the ABS function, but you need to watch out for errors that such shortcuts may introduce to your calculations: =ABS(DAYS("12/15/2010"; ...