Tom’s Tutorials for Excel: How old are you? Undocumented DATEDIF

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"
Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
One comment on “Tom’s Tutorials for Excel: How old are you? Undocumented DATEDIF
  1. Crystal says:

    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 🙂

Leave a Reply to Crystal Cancel reply

Your email address will not be published. Required fields are marked *

*