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

DateOfAge

DateOfAge returns a date at which a given age will be attained, based on a date of birth.

Syntax

DateOfAge (Age, Birthdate, [Method])

Parameter Name

Description

Age

Age.

Birthdate

Date of birth.

Method

The method to determine the date of the specified age.
Optional, default = 0.

Method

Description

0

Exact. If Birthdate is a leap day, and if the year of the specified age is not a leap year, then the Birthdate is treated as February 28.

1

1st day of month coincident or next following.

2

1st day of next month.