| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add months and adding partial monhts | Excel Worksheet Functions | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Convert years to years and days | Excel Discussion (Misc queries) | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
![Sai Krishna[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
