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 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

"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

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