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

 

[Special-K99]

=DATE(RIGHT(A1,2),LEFT(A1,2)+18,1)

where A1 is the date

 

[xymcrush17]

the result is 5/1/1914

not 2014

 

[FormR]

Try:

Excel Workbook
	A	B	C
1	1112	18	05-2014
Sheet1

 

[xymcrush17]

i have tried the result of your formula is 07-2013

 

[FormR]

This assumes all your dates are in the 21st century.

Does this work for you?

=TEXT(DATE("20"&RIGHT(A1,2),LEFT(A1,2)+B1,1),"mm-yyyy")

Where B1 contains 18

 

[Special-K99]

I'm sure there's a shorter way

=DATE(YEAR(DATEVALUE("01/"&LEFT(A1,2)&"/"&RIGHT(A1,2))+0),LEFT(A1,2)+18,1)

 

[xymcrush17]

i just tricked with your formula
thanks you add with 20 be 112012

the result i got is May-14

 

[FormR]

i just tricked with your formula
thanks you add with 20 be 112012

the result i got is May-14

Sorry, I don't follow?

 

[Jborg]

Try this: Do not forget the cell ref:

=DATE(YEAR("1january"&RIGHT(B5,2)),LEFT(B5,2)+18,5)