Completed years and monhts

S

Sai Krishna

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
 
M

Mike H

Maybe,

With Date of Birth in B2 try this and drag down

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

Mike
 
S

Stefi

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

Regards,
Stefi


„Sai Krishna†ezt írta:
 
S

Sai Krishna

Thanks, this helped.
regards
krishna


Mike H said:
Maybe,

With Date of Birth in B2 try this and drag down

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

Mike
Click to expand...
 
M

MissV

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
Excel - Calculate age from DOB in years, months days 7
calculate average values for 100 records in the shortest way? 5
Date and years calculation 2
Date Formula 85 factor 7
Excel Formula for years and months 2
Date difference to show in years and months 2
Date formula rounded up 2

Top