Die Jare () funksie gee terug Die verskil tussen twee datums in Jare. Die derde parameter dui aan Die berekening modus: as Die modus is 0, Jare () gee terug Die maksimum moontlik nommer van Jare tussen daardie dae. as Die modus is 1, dit slegs gee terug volledige Jare, beginne na Die 1st Jan en wat eindig op Die 31ste Des.
The YEARS() function returns the difference between two dates in years. The third parameter indicates the calculation mode: if the mode is 0, YEARS() returns the maximal possible number of years between those days. If the mode is 1, it only returns whole years, starting at the 1st Jan and ending on the 31st Dec.