This calculation takes into account the different number of days in a month as well as leap years and negative distances. The result is provided as a line separated list containing Years, Months, Days, and a compound string like "20 years, 5 months, and 7 days". To access these results use LeftValues (), MiddleValues (), and RightValues () respectively.

This calculation takes into account the different number of days in a month as well as leap years and negative distances and the time. The result is provided as a line separated list containing Years, Months, Days, Hours, Minutes, Seconds. To access these results you may use MiddleValues (x; 1), where x is (1) Years, (2) Months, (3) Days, (4) Hours, (5) Minutes, and (6) Seconds. For other requirements you may adjust the result format as you like.

You may download the sample file that contains both Custom Functions agecalc2.fp7.zip (10 kByte) for exploration.