Are you sure? 12 days in a month? This gives 62 months for the example
quoted, whereas it should presumably be 24 months (and not the 36 quoted by
the OP). DATEDIF seems the appropriate answer.
--
David Biddulph

"Cimjet" wrote in message
...
Hi Dimitri
Try this =(A1-TODAY())/12 and format cell as "General"
Regards
Cimjet
"Dimitri" wrote in message
...
Hello:

I was hoping that this formula is plausible. In A1 there is a date
14/04/2010, what I am looking for in B1 is a forumla that will tell how
many
months are remining from today's date.

A1 B1
01/04/2010 36

Thank you

Dimitri