Completed years and monhts
 

Hi,

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date of
joining. This gives results in fractions which may not be intelligible to a
reader.

Can anybody help?

regards
krishna

Completed years and monhts
 

Try with the DATEDIF function. Chip Pearson explains how to use it
he

http://www.cpearson.com/excel/datedif.aspx

Hope this helps.

Pete

On May 23, 8:40*am, Sai Krishna
wrote:
Hi,

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date of
joining. This gives results in fractions which may not be intelligible to a
reader.

Can anybody help?

regards
krishna

Completed years and monhts
 

Maybe,

With Date of Birth in B2 try this and drag down

=DATEDIF(B2,TODAY(),"y")& " Years" & DATEDIF(B2,TODAY(),"ym") & " Months"

Mike

"Sai Krishna" wrote:


Hi,

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date of
joining. This gives results in fractions which may not be intelligible to a
reader.

Can anybody help?

regards
krishna

Completed years and monhts
 

What about
=YEAR(TODAY())-YEAR(B2)
where B2 contains the date of birth.

Regards,
Stefi


€žSai Krishna€� ezt Ã*rta:


Hi,

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date of
joining. This gives results in fractions which may not be intelligible to a
reader.

Can anybody help?

regards
krishna

Completed years and monhts
 

Thanks, this helped.
regards
krishna


"Mike H" wrote:

Maybe,

With Date of Birth in B2 try this and drag down

=DATEDIF(B2,TODAY(),"y")& " Years" & DATEDIF(B2,TODAY(),"ym") & " Months"

Mike

"Sai Krishna" wrote:


Hi,

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date of
joining. This gives results in fractions which may not be intelligible to a
reader.

Can anybody help?

regards
krishna

Completed years and monhts
 

This is useful. But it rounds off.
regards
krishna


"Stefi" wrote:

What about
=YEAR(TODAY())-YEAR(B2)
where B2 contains the date of birth.

Regards,
Stefi


€žSai Krishna€� ezt Ã*rta:


Hi,

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date of
joining. This gives results in fractions which may not be intelligible to a
reader.

Can anybody help?

regards
krishna

Completed years and monhts
 

i found the DATEDIF function earlier on Petes recommendation, has some very
useful date calculation examples, really good.

"Pete_UK" wrote:

Try with the DATEDIF function. Chip Pearson explains how to use it
he

http://www.cpearson.com/excel/datedif.aspx

Hope this helps.

Pete

On May 23, 8:40 am, Sai Krishna
wrote:
Hi,

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date of
joining. This gives results in fractions which may not be intelligible to a
reader.

Can anybody help?

regards
krishna

Completed years and monhts
 

What age does that given for someone born in December 2000, Stefi ?
--
David Biddulph

"Stefi" wrote in message
...
What about
=YEAR(TODAY())-YEAR(B2)
where B2 contains the date of birth.

Regards,
Stefi


"Sai Krishna" ezt írta:


Hi,

I need to compute age/years of experience etc of our associates. The
results
have to be in completed years and completed months till date or as on a
particular date.

The first column has the name, the next the date of birth in date format
and
the next should be the answer of age or years of experience in completed
years and months.

I normally use= today() minus cell containing the date of birth or date
of
joining. This gives results in fractions which may not be intelligible to
a
reader.

Can anybody help?

regards
krishna