Formula vs Date vs UpperCase?

[Ken]

Excel 2000 ...

Cell A2 contains a date ... mm/dd/yy
Cell B2 contains a date created by formula off of A2
(format = mm/dd)
Cell C2 contains a date created by formula off of B2

If B2 = 05/18 and I want C2 to = UpperCase "MAY" ... How
do I do this? ... I thought, Custom Format MMM ...
However, this keeps returning "May". When I tried UPPER
function in front of formula in C2 ... it returned a Date
Serial# which I can't seem to format to "MAY".

Above said ... I want C2 & similar cells to contain 1st 3
characters of all months in UPPER Case ... How do I
achieve?

Thanks ... Kha

 

[Arvi Laanemets]

Hi

=UPPER(TEXT(A2,"mmmm"))