How to leave a cell empty with IF Formula + month formula

[Maci3j]

Hello readers,

I would like to use the IF function so when cell B2 is empty, cell C2 will stay empty. the formula =MONTH(B2&C2) need to be used when cell B2 is not empty. this to convert text to number in column C


This is the result that I would like to achieve

A	B	C	D	E
1	MONTH IN TEXT	MONTH IN NUMBER
2	MAY	5
3
4	JUNE	6

<TBODY>
</TBODY>

Thnx in advance

 

[kevatarvind]

=if(b2="","",month(b2))

 

[Weazel]

maybe something like

=IF(B2="","",MONTH(DATEVALUE(B2&" 1")))

 

[Maci3j]

the right formula is
=IF(b2="";"";Month(B2&C2))

thank you for your help