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

C

Colin Hayes

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

Colin Hayes

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

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

would return APR
Click to expand...

HI

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


^_^


Best Wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct and weekday from mm/dd/yyyy format? 3
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
How to show only Month of a mm/dd/yyyy format? 4
Changing date to eliminate day in format mm/dd/yyyy 1
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Month (MMM) from date (dd/mmm/yy) 1
date in mm/dd/yyyy 4
Forcing a date entry format of dd/mm/yyyy 1

Top