Convert date to age
How can I convert a date (8/12/50) to age (59)
|
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) |
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) |
All times are GMT +1. The time now is 06:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com