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

[Ron]

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]

Hi Ron

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

Regards

Roger Govier

 

[Ron]

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]

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