formula request

A

A. Toczko

Column A contains a date, entered as 21/04/05, which is formated to display
as Apr-05. I would like to have Column B display "April" or even "Apr", a
text result. I've tried the MONTH function, but that gives me a number.
Suggestions? Thank you.
 
G

Guest

=CHOOSE(MONTH(D11),"Jan","Feb","Mar"...

or you could try using Custom in the Number tab under the Format/Cells menu,
then type in:

mmmm

That will give you the name of the month.

Hope that helps and if it does, please vote for this post.

G.Morales
 

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

Month (MMM) from date (dd/mmm/yy) 1
Date difference Average 7
Countif OR Sumproduct OR Istext???? 2
Multi NetWorkDays Calculation 3
Help on Pivot Table 2
Reformatting dates as text 1
copy formula 3
Help required in Formula for date 17

Top