DateDif

Hello,
Help me to sort out this problem. I have to calculate number of months between two month end dates. As interest is payable for period from due date to date of payment .I am using Datedif function .
Example:
Cell A1 contains due date say 31st July, 2006
Cell B1 contains payment date say 31st Jan, 2007
Cell C1 contains formula =datedif(A1,B,"m")
This correctly gives number of months as 6
But if date in cell B1 is changed to 28th Feb, 2007 , still answer is 6, which should be 7

Any suggestion

Thanks

Hi,

Change your formula to:

=DATEDIF(A1,A2+1,"m")

See Chip Pearson's site on the DATEDIF function for more info.

http://www.cpearson.com/excel/datedif.htm

HTH

Steve

Used different references so change yourr's as needed.


Cheers,

Steve

Thanks for reply

You're welcome.

Steve