Tom’s Tutorials for Excel: How old are you? Undocumented DATEDIF.
Tom Urtis’ “Tom’s Tips for Excel” are being read so widely we are trying to share more of them, quick ones, longer ones & illustrated ones, each week. We welcome your comments & feedback. Do you prefer certain types of tips? Is there something you would like Tom to address? Enjoy and Excel!!
To see your (or someone else’s) age in years, months, and days with the undocumented DATEDIF function:
• In cell A1 enter the date of birth.
• In cell A2 enter the function =TODAY()
• In some other cell, enter this formula:
=DATEDIF(A1,A2,"Y")&" years, "&DATEDIF(A1,A2,"ym")&" months, "&DATEDIF(A1,A2,"md")&" days"
Hi Tom, adding on … my favorite date calculation (doesn’t need DateDif): find out how many days you have been alive: =A2-A1 ~Crystal * have an awesome day 🙂