Hi,

You can try the formula =DATEDIF(Start date,end date,"m"). For eg, where
Start date is in cell A1 and end date in cell B1, use =DATEDIF(A1,B1,"m").

However, this formula would compute only completed months elapsed
between start date and end date.

Regards

Govind.

billy wrote:
Hi,

I have two dates: 1/1/01 & 5/25/04
How can i write a formula that will show the number of months from 1/1/01
thru 5/25/04? This should show 53. I don't need days but months.

Thanks,