N NeilT Sep 29, 2009 #1 I would like to work out a persons age as at a given date for a list of people
J Jacob Skaria Sep 29, 2009 #2 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
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
S Stefi Sep 29, 2009 #3 =DATEDIF(A2,B2,"y") A2: date of birth B2: given date Regards, Stefi „NeilT†ezt Ãrta:
