Using dates with text

[MinerExcel]

Hello,

Please if anyone can help. I think this is possible without a VBA but I can't figure it out. I want a cell coded with a custom date format and general formatting. In a cell lets say S1 I tried making up this formal. =W1&" - "&A2&" "&VLOOKUP(Q2,AB5:AC28,2,FALSE)&" "&X1&" PRODUCTION" The result was 42525 - BQ EAST 10 42525 PRODUCTION. W1 is a date from another sheet formatted as yyyy mm X1 is the same date formatted as mmmm I want that in all caps. So I would like the result to read 2016 06 - BQ EAST 10 JUNE PRODUCTION. I thought formatting the date to the form I wanted in other cells would be easiest. I hope I have explained my problem and the solution I am looking for well enough.

Thank you

 

[MinerExcel]

Never mind I'm an idiot this is the formula I needed =TEXT('06-04'!A5,"yyyy mm")&" - "&A2&" "&VLOOKUP(Q2,AB5:AC28,2,FALSE)&" "&UPPER(TEXT('06-04'!A5,"MMMM"))&" PRODUCTION"