YEARS: OpenOffice.org is better than MS Excel

Calculates the difference in (interval) years between two dates.



MS EXCEL
=IF(TODAY()<DATE(YEAR(J2)+YEAR(TODAY())-YEAR(J2),MONTH(J2),DAY(J2)),YEAR(TODAY())-YEAR(J2)-1,YEAR(TODAY())-YEAR(J2))
OpenOffice.org
=YEARS(J2;TODAY();0)

OpenOffice.org 2.1 Help:
YEARS

Calculates the difference in years between two dates.
Syntax

YEARS(Start date, End date, Type)

Start date: First date

End date: Second date

Type: Calculates the type of difference. Possible values are 0 (interval) and 1 (in calendar years).

Blogger of jlcheng@openoffice.org

Hello world. I am jlcheng@openoffice.org. I will use this blogger website to discuss OpenOffice.org and SuSE linux and other Free software.

Better Free software, better life.