Another simple formula needed

[Guest]

In A3 there's a date, in date format: May-24-06. In B3 I would like a
formula that would insert MAY, picking up the month from A3. If the date in
A3 is Apr-18-06, then I would like B3 to yield APR, and so on. Connie

 

[Guest]

in B3

=A3

& use a custom format of MMM

 

[William Okumu]

You Can use also choose function and nest it with month
eg if your date is in A1, the the formulae will be

=Choose(month(a1),"Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec"

 

[Guest]

This works. Thank you very much. Connie

 

[Guest]

This is a much simpler way of doing it than William Okumu's formula, however,
his works better. The reason is, even though I formatted the column to MMM
for the month, it insists on putting the date as May instead of MAY. I
changed William's formula to include 3-letter capitalized months and it works
that way. Connie

 

[Guest]

William, it would be helpful that when you respond to a question that the
question itself appear in your post because I print my answers that work to
keep for future reference, and when I look at yours some day I will wonder
"what was the question????" Connie

 

[Guest]

=UPPER(TEXT(A3,"MMM")) will put text in upper case