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?

No comments:

Post a Comment