Work oiut a persons age at a given date

[NeilT]

I would like to work out a persons age as at a given date for a list of people

 

[Jacob Skaria]

With date of birth in A1 and the date in B1; try the below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "

'as of today
=DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&" months "

For details around calculating age refer
http://www.cpearson.com/excel/datedif.aspx

'Another option. Please note the difference of the below funciton when
compared with DATEDIF
=--TEXT(TODAY()-A1,"yy")

If this post helps click Yes

 

[Stefi]

=DATEDIF(A2,B2,"y")
A2: date of birth
B2: given date

Regards,
Stefi

„NeilT†ezt írta: