how do I calculate the age of a person
 

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

how do I calculate the age of a person
 

One way:

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

In article ,
S wrote:

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

how do I calculate the age of a person
 

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"JE McGimpsey" wrote:

One way:

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

In article ,
S wrote:

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

how do I calculate the age of a person
 

"Dave F" wrote in message
...
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


with @tiscali.co.uk

how do I calculate the age of a person
 

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Sandy Mann" wrote:

"Dave F" wrote in message
...
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


with @tiscali.co.uk

how do I calculate the age of a person
 

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


"S" wrote:

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