Excel Formula

[vijaychennai]

Hello all,

Good day !!

I have excel in the below format.

Excel Workbook
	A
1	Date
2	11/08/2011 10:28:00
Sheet1

I required month & Year in the below format.

Excel Workbook
	A	B
1	Date	Answer
2	11/08/2011 10:28:00	Nov'11
Sheet1

 

[Jonmo1]

Try

=TEXT(A2,"mmm'yy")

 

[vijaychennai]

Working Fine Great