The reason it doesn't work without the quote marks is that in
that case Excel is treating the '/' character as the division
operator rather than a date separator.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Ron" wrote in message
...
"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