Showing posts with label DATEIF. Show all posts
Showing posts with label DATEIF. Show all posts

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?