Date formatting Q

[tamaramb]

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

[shg]

It can't be done with a format, but you could use a formula:

	A	B	C
1	11/07/2016	11JUL - 15JUL	B1: =UPPER(TEXT(A1, "ddmmm - ") & TEXT(A1 + 4, "ddmmm"))