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

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

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

"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

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

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