calculating age

[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

 

[Domenic]

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 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!

 

[Jerry W. Lewis]

=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

 

[Don Guillett]

try this
=DATEDIF(A1,TODAY(),"y")

 

[Dave Peterson]

You may want to visit Chip Pearson's site to see a nice explanation of
=Datedif()

http://www.cpearson.com/excel/datedif.htm

 

[Paul BRYAN]

With a slight amendment it works fine

Thanks

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!

 

[Domenic]

With a slight amendment it works fine

Thanks

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

Cheers!

 

[JER]

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

 

[Domenic]

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

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!