Excel Functions in EAC ToolsExcel Functions in EAC Tools\Age, date, more functionsAge, date, more functions\AgeToText

AgeToText

AgeToText returns the text equivalent of an age the form of “Y yr M mo”.

For example, AgeToText(65.33) returns “65 yr 4 mo”.

Syntax

AgeToText (Age)

Parameter Name

Description

Age

Age as a number, in years and whole months.