Convert an abbreviated month name to an integer

[mikeymay]

I want to convert an abbreviated month name, e.g. Jan, Feb, Mar, etc into an integer that represents the month number, eg Jan = 1, Feb = 2, etc

Seems an easy thing to do the other way round, but am struggling with this.


Thanks

 

[sunnyland]

Hello,

2 ways I can think off :

New_Plat_Cust_Form.xls
	A	B	C	D	E
1	MonthChar	MonthInt		MonthChar	MonthInt
2	Feb	2		Jan	1
3	Mar	3		Feb	2
4				Mar	3
5				Apr	4
6				May	5
7				Jun	6
8				Jul	7
9				Aug	8
10				Sep	9
11				Oct	10
12				Nov	11
13				Dec	12
New

Formula in B2:
=((A2="Jan")*1)+((A2="Feb")*2)+((A2="Mar")*3) will have to be expanded to ....((a2="Dec)*12)

formula in b3 uses vlookup easier to implement as if you type 1 and drag down to series, you don't have to type .
Same for Jan, drag down will increment the months.

 

[onlyadrafter]

Hello

try

=MONTH("1/"&C25)