Work oiut a persons age at a given date
 

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

Work oiut a persons age at a given date
 

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
---------------
Jacob Skaria


"NeilT" wrote:

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

Work oiut a persons age at a given date
 

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

Regards,
Stefi

€žNeilT€� ezt Ã*rta:

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