Date difference in OpenOffice to calculate
- You want to display the difference in days, you need to subtract the end date with the start date. Openoffice recognizes ind he usually automatically add the Numbers as "date", otherwise, you can Format by right-click - > "cell" yet repair.
- If in column B1 is the start date and in column C1, the end date is, is the formula "=B1-C1".
- You want to display the result (in column D1) in years, use the formula "=D1/365".
OpenOffice: Date-Difference
Read in another practical tip on how you can in OpenOffice multiple languages to enable.
