| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating present age if date of birth is given.
That would be fine if all years were 365 days, Mark.
For a value of 30 Jul 1960 in A1, that returns 48 years and a bit besides. Try =DATEDIF(A1,B1,"y") or =DATEDIF(A1,TODAY(),"y") -- David Biddulph "NoodNutt" wrote in message ... G'day Harsh Assume A1 = Birthdate = 06-Mar-1960 Format as Date B1 = Now() = 25-Jul-2008 Format as Date C1 = (B1-A1)/365 = 48yo Format as Number HTH Mark. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Birth date from age | Excel Worksheet Functions | |||
| calculating month of present date | Excel Discussion (Misc queries) | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| calculating age by birth date using excel | Excel Worksheet Functions | |||
| calculating the future value of a present value | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
