how do I calculate the age of a person

[Guest]

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

 

[JE McGimpsey]

One way:

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

 

[Guest]

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

Dave

 

[Sandy Mann]

If someone is born on March 15 2006 they are 1 year old

Not for another two days they're not

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

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

Dave

 

[Guest]

Thanks that was the answer I was looking for...I apreciate your time...