Determining Current Age

[BrooksTech]

I keep getting 1905 or some long number when trying to use =NOW() when determining a persons current age. The data available is as follows:

AGE (At Specified Year)

YEAR (Specified Year Will be a year Between 1950 and 2011)
or
BIRTH YEAR (Either Calculated if missing or hardcoded)

I will then subtract the Birth Year from the Current Year, via =NOW(), AND also to determine age at the Specified Year do a calc subtracting Spec.Year from Birth Year. In the former, I will get a five digit number, and in the latter end up with, not a two-digit age as expected, but "1905" in every instance. All the year columns are formatted YYYY and the age column as a number with no decimal places.

 

[shg]

Maybe ...

      ---B--- -C-- -------------D--------------
  3   Age       36                             
  4   Year    1999                             
  5                                            
  6   Age now   48 C6: =C3 + YEAR(TODAY()) - C4

 

[T. Valko]

I keep getting 1905 or some long number when trying to use =NOW() when determining a persons current age. The data available is as follows:

AGE (At Specified Year)

YEAR (Specified Year Will be a year Between 1950 and 2011)
or
BIRTH YEAR (Either Calculated if missing or hardcoded)

I will then subtract the Birth Year from the Current Year, via =NOW(), AND also to determine age at the Specified Year do a calc subtracting Spec.Year from Birth Year. In the former, I will get a five digit number, and in the latter end up with, not a two-digit age as expected, but "1905" in every instance.

I think you first have to extract the year from NOW(). NOW() returns the current date and time.

To get the current year:

=YEAR(NOW())

 

[BrooksTech]

Thanks guys.

 

[T. Valko]

Thanks guys.

You're welcome!