Hi,

I have a question regarding date formatting.

I have a pivot table where I have grouped individual dates into weeks i.e. 11/07/2016 = 11/07/2016 - 15/07/2016. I need to pull the range of weeks from the pivot table into a separate table and change the formatting to text i.e. 11/07/2016 - 15/07/2016 = 11JUL - 15JUL.

Could someone please tell me if there is a way of doing this? I have tried customising in format cells and even tried the TEXT function but neither have worked.

Thanks