Count of remaining months

  • Thread starter Thread starter Raj
  • Start date Start date
R

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
 
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
 
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
 
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
Click to expand...

Hi,

Typed in as values ie Oct-09

Regards,
Rajendra
 
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
 
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
 
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
Click to expand...

Thanks John for the solution.

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

Regards,
Raj
 
Back
Top