calculating age

  • Thread starter Thread starter Paul BRYAN
  • Start date Start date
P

Paul BRYAN

Hi

trying to work out a formula to calculate the age of a person:-
If the persons 'date of birth' is in cell 'A1', how can I display their age
in cell 'A2'

Thanks

Paul
 
Hi

trying to work out a formula to calculate the age of a person:-
If the persons 'date of birth' is in cell 'A1', how can I display their age
in cell 'A2'

Thanks

Paul
Click to expand...
Hi Paul,

Here's one way:

=IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))<=TODAY(),YEAR(TODAY())-YEAR(A1),(Y
EAR(TODAY())-YEAR(A1))-1)

Cheers!
 
=YEAR(TODAY())-YEAR(A1) will their age after their birtday this year.
=EDATE(A1,12*(YEAR(TODAY())-YEAR(A1))) is their birthday this year
so
=YEAR(TODAY())-YEAR(A1) -IF(TODAY()<EDATE(A1,12*(YEAR(TODAY())-YEAR(A1))),1)
is their age.

Jerry
 
With a slight amendment it works fine

Thanks

Domenic said:
Hi Paul,

Here's one way:

=IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))<=TODAY(),YEAR(TODAY())-YEAR(A1),(Y
EAR(TODAY())-YEAR(A1))-1)

Cheers!
Click to expand...
 
With a slight amendment it works fine

Thanks
Click to expand...

Oh, I see. You probably changed it to deal with an empty cell. Overlooked
that one. Thanks for letting me know.

Cheers!
 
A novice in excel I am. Curious about how you did that. If I copy the
formula in cell and place the date of birth in cell A ... I get #name?
Please, some more help

Jerry
 
A novice in excel I am. Curious about how you did that. If I copy the
formula in cell and place the date of birth in cell A ... I get #name?
Please, some more help

Jerry
Click to expand...

The #NAME error occurs when Excel doesn't recognize text in a formula. If
you typed the formula into the formula bar yourself, it's possible that
there may be a typing mistake. The formula should work.

Try,

1) Enter a date in cell A1, making sure that it's in the proper format. For
example, 6/18/1960, June 18, 1960, etc.

2) Select this formula -->
=IF(A1="","",IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))<=TODAY(),YEAR(TODAY())
-YEAR(A1),(YEAR(TODAY())-YEAR(A1))-1))

3) Edit > Copy

4) Select cell B1, press =

4) Edit > Paste and hit return

Hope this helps!
 
Back
Top