I'm using Datedif to calculate number of months between 2 dates. Can anyone advise how to fix this please?
Consider the following example -
H29 - 20-Jul-22
J29 - 19-Sep-22
Datedif -
This returns 1 instead of 2.
Consider the following example -
H29 - 20-Jul-22
J29 - 19-Sep-22
Datedif -
Excel Formula:
=IFERROR(DATEDIF(H29,J29,"m"),"")
This returns 1 instead of 2.