| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Producing Age Based on Date of Birth
Given I have a cell with a person's date of birth (mm/dd/yyyy) can I have another cell perform a function where it produces the person's current age based on their DOB? -- MPuser |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Producing Age Based on Date of Birth
Hi
With their DOB in A1 =DATEDIF(A1,TODAY(),"y") for years =DATEDIF(A1,TODAY(),"ym") for additional months ="Age today is "&DATEDIF(A1,TODAY(),"y")&" years "&=DATEDIF(A1,TODAY(),"ym")&" months" Regards Roger Govier MPuser wrote: Given I have a cell with a person's date of birth (mm/dd/yyyy) can I have another cell perform a function where it produces the person's current age based on their DOB? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| sum based on date in excel | Excel Worksheet Functions | |||
| Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
| Convert formula to value based upon date | Excel Discussion (Misc queries) | |||
| sum automatically from last 12 months based on current date | Excel Worksheet Functions | |||
Hybrid Mode
