Hi,

I am using this formula to calculate the difference (in months) between two
dates;

=DATEDIF(A2,B2,"m")

However there is a problem. When using the above formula the difference
between these two dates-

1/4/2006 - 31/3/2006

The formual returns 11 months. This isn't correct as they are actually 364
days apart, and the difference I need to see for my purposes is 12 months.

Does anybody have a solution?

Many thanks