google sheets - Month function on googlesheets

Question

I'm using function =MONTH(A2) & =TEXT(A2,"MMM") to get the month number. However, If the date is blank it by default says 12 & Dec.

Any suggestion for a function which will say blank " " instead of default 12 or Dec?

question from:https://stackoverflow.com/questions/65901563/month-function-on-googlesheets

Answer 1

You could try

=if(A2="", "", MONTH(A2))

=if(A2="", "", TEXT(A2,"MMM"))