I think you need to look at your data again

=DATEDIF(A2,A1,"d")

Gives 152 days and

=DATEDIF(A2,A1,"m")

Gives the correct answer of 5 months between 30/10/2006 & 31/3/2007

Mike

"Carpe Diem" wrote:

Hi ,

I have the following dates:

31/03/2007
30/10/2006
09/12/1991

and I would like to check how many months do I have between dates, If
I use the year frac between the first and second will give 5 months
but the real value sholud be 6 . Can someone have a formula to check
this ?