You can use MONTH() and create a pseudo date for it: =MONTH(DATEVALUE(A1&" 1, 2017")). enter image description here. Or another variation on the same theme:
確定! 回上一頁