Count of remaining months

[Raj]

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

 

[Ashish Mathur]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Eduardo]

Hi,
Have somewhere two columns one with the month and other with the number
corresponding to that month and then apply a vlookup formula like

=VLOOKUP(C12,I1:J12,2,FALSE)-(VLOOKUP(D12,I1:J12,2,FALSE)-1)

C12 = December
D12= October

I1:j12 = the table mentioned above

 

[John]

HI
If current Month is in C2 and End Month is in B2.
=DATEDIF(c2,b2,"m") and the answer should be 2 not 3
HTH
John

 

[Rajendra]

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

Hi,

Typed in as values ie Oct-09

Regards,
Rajendra

 

[John]

If you need to include the current month in your answer, =DATEDIF(c2,b2,"m")+1
This will only work if they are real dates.
HTH
John

 

[John]

Going to fast, not thinking, try it it should work with text.

 

[Ashish Mathur]

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 MVP
www.ashishmathur.com

 

[Rajendra]

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







- Show quoted text

Thanks John for the solution.

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

Regards,
Raj