To make a formula work, I need to either change the date format in the pivot table (see tab "sheet1") or the raw data (see tab "data") - which is a formula. I need it to be in the format of "mmm-yy" - and no - going to the format cells menu doesn't work!!
Does anyone know of a formula that would work??