## Hello / Notify Bar Widget For Blogger Blogspot

You can calculate a persons age based on their birthday and todays date. The calculation uses the DATEDIF() function. The DATEDIF() i...

 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 : 38 =DATEDIF(C8,TODAY(),"y") and the months : 9 =DATEDIF(C8,TODAY(),"ym") and the days : 7 =DATEDIF(C8,TODAY(),"md") You can put this all together in one calculation, which creates a text version. Age is 38 Years, 9 Months and 7 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 : 01-Jan-60 Age is : 52.10 =(TODAY()-C23)/365.25

Name