Need formula result to show date in upper case

[Ironman]

Hi

Cell D8 contains the following formula

{=INDEX(LogYear_Log_Dates,MATCH(2,INDEX(1/(LogYear_Log_Miles=E8),0)))}

The result is a date in custom format ddd d mmm e.g Wed 6 Mar

I'm trying to change this to upper case and I'm having difficulty in doing so.

I'd be very grateful for a solution that avoids displaying the upper case result in a different cell.

Many thanks.

 

[Scott T]

It will be text instead of a excel date up will be in upper case

=UPPER(TEXT([COLOR=#333333]INDEX(LogYear_Log_Dates,MATCH(2,INDEX(1/(LogYear_Log_Miles=E8),0)))[/COLOR],"ddd d mmm"))

 

[Ironman]

Works perfectly Scott - many thanks to you!