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

Excel - Calculate age from DOB in years, months days 7
Calculating age from date of birth and ignoring if blank 5
How do I calculate a persn's age in years & months in Excel? 4
Date and years calculation 2
Calculating age of death 23
Date difference to show in years and months 2
Function to take today's date less someone's b-day to get their ag 1
Calculating age from date of birth 3

Top