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
|