Another simple formula needed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Connie Martin - 25 May 2006 14:20 GMT

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

Reply to this Message

Duke Carey - 25 May 2006 14:28 GMT

in B3

=A3

& use a custom format of MMM

> 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

Reply to this Message

William Okumu - 25 May 2006 15:21 GMT

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"

Reply to this Message

Connie Martin - 25 May 2006 15:38 GMT

This works. Thank you very much. Connie

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

Reply to this Message

Connie Martin - 25 May 2006 15:48 GMT

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

Reply to this Message

Connie Martin - 25 May 2006 15:42 GMT

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

> in B3
>
[quoted text clipped - 5 lines]
> > 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

Reply to this Message

Toppers - 25 May 2006 16:35 GMT

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

> 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
[quoted text clipped - 11 lines]
> > > 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

Reply to this Message