Converting months text to number !
Example Sep to 9 ??
A3 = Sep ' In cell A3 we have Sep as month text
Here we go :
=MONTH(DATEVALUE(A3&"1"))
Output = 9
Example Sep to 9 ??
A3 = Sep ' In cell A3 we have Sep as month text
Here we go :
=MONTH(DATEVALUE(A3&"1"))
Output = 9
No comments:
Post a Comment