***AGE CALCULATION***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 : | 29-Apr-73 | | | | | |
| | | | | | |
| Years lived : | 37 | =DATEDIF(C8,TODAY(),"y") | | | |
| and the months : | 11 | =DATEDIF(C8,TODAY(),"ym") | | |
| and the days : | 21 | =DATEDIF(C8,TODAY(),"md") | | |
| | | | | | |
| You can put this all together in one calculation, which creates a text version. | | |
| Age is 37 Years, 11 Months and 21 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 : | 51.30 | =(TODAY()-C23)/365.25 | | | |
