Date Difference in Month

[Kumar]

Hi All,

I want to get the difference between two dates in the period of month.

For Example i need difference between 16/09/2009 and 01/09/2010

I used the datediff function (datediff("m","16/09/2009","01/09/2010"))

it gives output as "4" can anyone help in this....


Thanks in Advance

Kumar

[Bob Phillips]

Try

=DATEDIF("01/09/2009","16/09/2009","M")