Month() function doesn't work to convert January to 1

[dngandbored]

Hi there, I tried to use the month() function to convert month (January, February etc) to numeric format in Excel. It doesn't work. I don't know what went wrong. Please see my screenshot below
I typed "March" in C4 and try to convert to "3" by using month( ) but I couldn't please help!!

 

[MARK858]

Welcome to the forum, you need a real date for the month function to work, try...

Book1
	C	D
1
2
3	January	1
4	February	2
5	March	3
6	April	4
7	May	5
8	June	6
9	July	7
10	August	8
11	September	9
12	October	10
13	November	11
14	December	12
Sheet3

Cell Formulas
Range	Formula
D3:D14	D3	=MONTH(DATEVALUE(C3&" 1"))

 

[GWteB]

Hi & welcome to MrExcel!

The MONTH worksheet function expects a date type instead of a text type. So tell us what you're trying to achieve.

 

[dngandbored]

Still didn't work

 

[dngandbored]

Hi & welcome to MrExcel!

The MONTH worksheet function expects a date type instead of a text type. So tell us what you're trying to achieve.

I basically want to rank my data from January to December, I have multi year data so I was thinking to convert 2014 January to date format so I can rank them...

 

[MARK858]

That isn't the formula I posted, note where the space is in the " 1" (much easier if you copied what I posted by clicking the

and pasted into your sheet)

 

[dngandbored]

That isn't the formula I posted, note where the space is in the " 1" (much easier if you copied what I posted by clicking the View attachment 51185 and pasting into your sheet)

I just did and I got this.. could it be a version issue with Excel?

 

[Peter_SSs]

OP's original formula as posted works for me.

21 11 14.xlsm
	C	D
4	March	3
Month

Cell Formulas
Range	Formula
D4	D4	=MONTH(C4&1)

 

[MARK858]

could it be a version issue with Excel?

No, you are running 365, the same as me and all the functions used are old.

OP's original formula as posted works for me.

Yes, looking at the formula in the image it works for me also (my bad, I only looked at the OP's text)

 

[Peter_SSs]

In the image from post #4 it looks like you have incorrect quote marks - they need to be the 'vertical' quote marks not the sloped ones.

However, that does not explain the failure of the original formula that has no quote marks in it.