| You can calculate a persons age based on their birthday and todays date. | |||||||
| The calculation uses the DATEDIF() function. | |||||||
| The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000. | |||||||
| (Makes you wonder what else Microsoft forgot to tell us!) | |||||||
| Birth date : | 1-Jan-60 | ||||||
| Years lived : | 53 | =DATEDIF(C8,TODAY(),"y") | |||||
| and the months : | 8 | =DATEDIF(C8,TODAY(),"ym") | |||||
| and the days : | 17 | =DATEDIF(C8,TODAY(),"md") | |||||
| You can put this all together in one calculation, which creates a text version. | |||||||
| Age is 53 Years, 8 Months and 17 Days | |||||||
| ="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days" | |||||||
| Another way to calculate age | |||||||
| This method gives you an age which may potentially have decimal places representing the months. | |||||||
| If the age is 20.5, the .5 represents 6 months. | |||||||
| Birth date : | 1-Jan-60 | ||||||
| Age is : | 53.71 | =(TODAY()-C23)/365.25 | |||||
Wednesday, 18 September 2013
Age Calculation
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment