"Roger Govier" wrote in message
...
Hi Ron

try
=DATEDIF(A15,"15/10/2011","m")

Regards

Roger Govier


Ron wrote:
Hi

=DATEDIF(A15,TODAY(),"m") gives the number of months, from a date in the
past, in A15. How can I get the number of months from A15 to say
15/10/2011?

Thanks Ron

Hi Thanks for that, I had tried that but never used "" around the date.
Ron