Sorry, didn't see your subject, use

=DATEDIF(earlier_date_later_date,"m")


but your date is still wrong, November has only 30 days and
if you mean 11/30/08 then it would be 15 months

and finally if you want to disregard the year you can use

=DATEDIF(C3,D3,"ym")

--


Regards,


Peo Sjoblom

"Peo Sjoblom" wrote in message
...
What are those dates supposed to be?

1. How can you expect to get 18 regardless and how can you get 5?

2. 31/11/2009 or 11/31/2009 US date format is a non-existent date, so that
will be a text string. There are only 30 days in November

Assume it was 11/30/2009

then the result would be

486 assuming that 01/08/2008 is the first of August 2008, if you are
mixing date format and
the first is US format and Jan 8 2008m then the difference would be 692

--


Regards,


Peo Sjoblom

"Jose" wrote in message
...
I have the following problem with dates:
C3 D3
01/08/2008 31/11/2009


When I ask D3-C3 I get 5 instead of 18. How am I doing wrong?
--
Many thanks for your help,
Jose