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.
De funksje JIERREN () berekkent it ferskil tusken twa data yn jierrren. De tredde parameter bepaalt de berekkeningsmetoade: as de metoade 0 is, dan jout JIERREN () it grutst mooglike oantal jierren werom tusken dizze dagen. As de metoade 1 is, dan jout de funksje allinnich it oantal hiele jierren fan 1 jannewaris oant 31 desimber.