DATEDIF To Calculate Differences In Dates

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?