Wednesday, April 25, 2007

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).

No comments: