This article show you how to count months between two dates using DATEDIF function.
Syntax
=DATEDIF(start date, end date, "m")
Steps
- Use =DATEDIF(
- Select or type range reference that includes start date B3,
- Select or type range reference that includes end date C3,
- Type "m" to specify month
- Type ) and press Enter to complete the formula
How
Most Excel users don't know about the DATEDIF function. Microsoft hasn't documented it since Excel 2000 and actually wants it to be forgotten. The DATEDIF function has been derived from Lotus 1-2-3 for compatibility and luckily still there to help us.
The DATEDIF function returns the difference between two dates by specified unit type. It gets 3 arguments, start date, end date and unit. The unit is a string that specifies the difference type that may be day, month, year or combination of them. For example; "m" string represents month and this is what we use in this article.
=DATEDIF(B3,C3,"m")
Also see articles how to convert D/M/YYYY date to M/D/YYYY or vice versa and how to count values if date is greater than by using COUNTIF function.
