how do I calculate the age of a person

S

S

Hi,

I need the age of a person in years but if they are less than one year old I
need it in months

I tried to do this myself but find it too hard, can anyone help me

Any help would be greatly appreciated

Susan
 
J

JE McGimpsey

One way:

=IF(DATEDIF(A1,TODAY(),"y")<1, DATEDIF(A1,TODAY(),"m") & " months",
DATEDIF(A1,TODAY(),"y") & " years")
 
D

Dave F

If someone is born on March 15 2006 they are 1 year old, however your formula
returns 11 months.

Dave
 
D

Dave F

Ha, yeah I realized that after I posted that. Was looking at March 15th on
my Outlook calendar and thought that was today.

Dave
 
Top