=DATEDIF(A15,TODAY(),"m")

Ron · Sep 28, 2005

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 · Sep 28, 2005

Hi Ron

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

Regards

Roger Govier

Ron · Sep 28, 2005

Roger Govier said:
Hi Ron

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

Regards

Roger Govier

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

Chip Pearson · Oct 4, 2005

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