One of the less known functions in Excel is =DATEDIF.
You can use the function =DATEDIF to calculate the difference between dates.
In the below example, I calculate in Cell B3 the difference between the date of June 10, 2011 and Date Born. I then convert the calculation into an easy to read reference.
What ways can you apply this formula?