With a date in B2 this formula give you the completed months between
B2 and today(you can use another cell also)

=IF(B2<=TODAY(),DATEDIF(B2,TODAY(),"m"),-DATEDIF(TODAY(),B2,"m"))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Claudine" wrote in message ...
hello. what's my formula if I want to get the number of months from let's
say 4/15/2005 to 4/30/2006? I know I can simply do a (4/30/06 less 4/15/05)
divided by 30. But that comes out as 12.66666. What's the best formula?

Thank you very much!
Claudine