Table of Contents
Example
We have to derive number of months between any two dates available in the data.
Formula
=DATEDIF(start_date, end_date, “M”)
Using the formula
- In a new column, type the following
=DATEDIF(A2,B2,”M”) - Using the above formula, we will get difference in number of months.
Notes:
1. DATEDIF formula will not appear in the by default list functions available in excel.
2. The result will show completed number of months between two dates.