Returning the month (mmm) from cell in date format dd/mm/yyyy
 

HI

In C3 I have date in the form dd/mm/yyyy.

I'm trying to return this in A3 as mmm.

EG

12/04/2010 in C3 would return upper APR in A3

Can someone help with this?

Grateful for any advice.


BTW I'd then need to incorporate the code into an existing formula in A3
:

=IF(C3="","",UPPER(LEFT(M$3,3)&TEXT(ROW()-3,"000")&-'Purchase
Record'!$A$1))

where the date coding would replace the M$3 part so if someone can also
help with this too I'd be double grateful.

Returning the month (mmm) from cell in date format dd/mm/yyyy
 

On Sun, 5 Feb 2012 01:09:40 +0000, Colin Hayes wrote:


HI

In C3 I have date in the form dd/mm/yyyy.

I'm trying to return this in A3 as mmm.

EG

12/04/2010 in C3 would return upper APR in A3

Can someone help with this?

Grateful for any advice.


BTW I'd then need to incorporate the code into an existing formula in A3
:

=IF(C3="","",UPPER(LEFT(M$3,3)&TEXT(ROW()-3,"000")&-'Purchase
Record'!$A$1))

where the date coding would replace the M$3 part so if someone can also
help with this too I'd be double grateful.


Assuming that the entry is a normal Excel date, and not a text string, then:

=UPPER(TEXT(C3,"mmm"))

would return APR

Returning the month (mmm) from cell in date format dd/mm/yyyy
 

In article , Ron Rosenfeld
writes
Assuming that the entry is a normal Excel date, and not a text string, then:

=UPPER(TEXT(C3,"mmm"))

would return APR

HI

OK Thanks for your help. This works perfectly first time.


^_^


Best Wishes

Returning the month (mmm) from cell in date format dd/mm/yyyy
 

On Sun, 5 Feb 2012 02:07:55 +0000, Colin Hayes wrote:

In article , Ron Rosenfeld
writes
Assuming that the entry is a normal Excel date, and not a text string, then:

=UPPER(TEXT(C3,"mmm"))

would return APR

HI

OK Thanks for your help. This works perfectly first time.


Glad to help. Thanks for the feedback.