On Oct 7, 6:47*am, "Ashish Mathur" wrote:
Hi,

If you typed in Oct-09, then it would have automatically become a date I.e.
the entry in the formula bar would be 1/10/2009. *Try this

=MONTH(E18)-MONTH(D18)+1

E18 has the ending month and D18 has the beginning month

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

"Rajendra" wrote in message

...



On Oct 6, 9:55 pm, "Ashish Mathur" wrote:
Hi,

Are these dates (1/1/2009 - formatted as mmm yy) or typed in values "Oct
09"?

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

"Raj" wrote in message

....

Hi,

A sheet has following columns:
Start Month * * End Month * * * Current Month *Remaining Months
July 09 * * * * * * Dec 09 * * * * * * * *Oct 09 * * * * * * * * * *3

How do I compute the remaining months using *formula/function?

Thanks in advance for the help.

Regards,
Raj

Hi,

Typed in as values ie Oct-09

Regards,
Rajendra- Hide quoted text -

- Show quoted text

Thanks John for the solution.

Ashish, the solution gave the same results for the same month in
different years.

Regards,
Raj