Another simple formula needed

C

Connie Martin

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
 
W

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"
 
C

Connie Martin

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
 
C

Connie Martin

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
 
Top