Count of remaining months
 

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

Count of remaining months
 

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

"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

Count of remaining months
 

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


"Raj" wrote:

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

Count of remaining months
 

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
"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

Count of remaining months
 

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

Count of remaining months
 

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" wrote in message
...
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
"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

Count of remaining months
 

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

"John" wrote in message
...
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" wrote in message
...
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
"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

Count of remaining months
 

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" 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

Count of remaining months
 

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