sum date format with number format

[xymcrush17]

hi mrExcel
I have data like this

1112 which mean (NOV-2012) and sum 18 which mean (1year 6 months) result I want is 05-2014 which mean ( May 2014)


thanks for advance

 

[xymcrush17]

im srry i mean the result is 05-2014 thnks you FormR

one more question is 06-2014 - 05-2014 is 31 how to convert in month thnks you

 

[FormR]

So your all good with the first question.

one more question is 06-2014 - 05-2014 is 31 how to convert in month thnks you

I don't understand the next question - could you elaborate?

 

[xymcrush17]

i mean i have date A1 05-2014
B1 06-2014
=B1-A1 is 31 (which mean 31 day)
how to convert to month the result is 1 month

 

[FormR]

Try:

=DATEDIF(B1,A1,"M")

 

[Peter_SSs]

I didn't understand what the final resolution was to the original question but it looked like FormR was giving solutions that suited UK date format but the OP seemed to be using US date format.
If that was the case, with 1112 in A1 and 18 in B1, does this produce the desired result?

=TEXT(EDATE(TEXT(A1,"00-1-00"),B1),"mm-yyyy")

It produces "07-2014" for me using UK date format but I think it should produce "05-2014" if the user is on US date format?

 

[xymcrush17]

not working #NUM

 

[Jborg]

Sorry forgot the TEXT bit: This is better

=TEXT(DATE(YEAR("1january"&RIGHT(B5,2)),LEFT(B5,2)+18,1),"MM-YYYY")

 

[Jborg]

Better still:

=TEXT(DATE(YEAR("1january"&RIGHT(B5,2)),LEFT(B5,2)+18,1),"MM-YYYY")

 

[FormR]

not working #NUM

It would be much easier if you just used proper date serial numbers and changed how they display with formatting.

But try (assuming you are using US date styles):

EDITED:

=DATEDIF(RIGHT(B1,4)&"-"&LEFT(B1,2)&"-01",RIGHT(A1,4)&"-"&LEFT(A1,2)&"-01","M")

 

[Peter_SSs]

It would also be helpful if you made it clear who or what you are referring to. For example, the following post was made after two completely different suggestions were made to you.

not working #NUM

It is entirely unlear whether that comment is to FormR or to me.