Another simple formula needed

[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

[Duke Carey]

in B3

=A3

& use a custom format of MMM

"Connie Martin" wrote:

> 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

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

[Connie Martin]

This works. Thank you very much. Connie

"William Okumu" wrote:

>
> 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")
>
>
> --
> William Okumu
> ------------------------------------------------------------------------
> William Okumu's Profile: http://www.excelforum.com/member.php...o&userid=33745
> View this thread: http://www.excelforum.com/showthread...hreadid=545472
>
>

[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

"Duke Carey" wrote:

> in B3
>
> =A3
>
> & use a custom format of MMM
>
> "Connie Martin" wrote:
>
> > 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

[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

"William Okumu" wrote:

>
> 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")
>
>
> --
> William Okumu
> ------------------------------------------------------------------------
> William Okumu's Profile: http://www.excelforum.com/member.php...o&userid=33745
> View this thread: http://www.excelforum.com/showthread...hreadid=545472
>
>

[Toppers]

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

"Connie Martin" wrote:

> 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
>
> "Duke Carey" wrote:
>
> > in B3
> >
> > =A3
> >
> > & use a custom format of MMM
> >
> > "Connie Martin" wrote:
> >
> > > 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