Month Function > Text to Number

Greetings,

It would be nice to be able to use the Month function like this:
=MONTH(A3&1)

to convert text to number > Nov = 11

1 Like

Welcome back Benjamin,

The following seems to do the job. Put in any static value for year and day.

=MONTH(DATEVALUE(CONCATENATE(“2021-”,A2,"-1")))

image

My colleague says that MONTH is an overkill in this case. A better solution is to use MATCH

=MATCH(A3,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"})

2 Likes

thanks!
that worked!

1 Like