Dear
A B C D
Date Month Year Arr_date
13 5 2016 =date(c2,b2,a2) - it shown 2016-5-13

However, i would like to show as "May-13 " ( i need to show the month and year, as i then take this for Pivot Table , so i need that just MMM-YY


How can i do that ?

Eric