YearMonth format with '

[#1]

Hi

I need to show a date format where ' is part of the format, and I need to show only the first letter of the Month.

So 2015 January should be 15'J, and both Marts and May is M.  

[pratap6699]

=Date(month,'YY') & Chr(39) & Upper(Left(Month(Date(month,'MMM')),1))