| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert date to age
How can I convert a date (8/12/50) to age (59)
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to age
Try
=DATEDIF(A1,TODAY(),"y")+1 Or =YEAR(TODAY())-YEAR(A1) If this post helps click Yes --------------- Jacob Skaria "margoalicia" wrote: How can I convert a date (8/12/50) to age (59) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert date to age
You'll have to explain to us how you calculate 59.
A birthday of either 8 Dec 1950 or 12 Aug 1950 would generally be regarded a giving an age of 58 as at 13 July 2009. The formula would be =DATEDIF(A1,TODAY(),"y") If what you want is what age someone born in 1950 will attain during 2009, try =YEAR(TODAY())-YEAR(A1) -- David Biddulph "margoalicia" wrote in message ... How can I convert a date (8/12/50) to age (59) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert Gregorian date into Hijri Date in Excel 2007? | Excel Discussion (Misc queries) | |||
| How do you convert an uncoded date (e.g., 20080304) to a date form | Excel Worksheet Functions | |||
| to convert a julian date back to regular date | Excel Worksheet Functions | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
| how to convert julian date to regular calendar date | Excel Worksheet Functions | |||
Linear Mode
