| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between dates returning full months and remaining days | Excel Discussion (Misc queries) | |||
| Determine the months remaining from date to the end of the yea | Excel Discussion (Misc queries) | |||
| dynamic calculation of months remaining given end date and today | Excel Discussion (Misc queries) | |||
| Count workdays remaining in a month | Excel Discussion (Misc queries) | |||
| Months or Years remaining, formatting | Excel Discussion (Misc queries) | |||
![Raj[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
