CODEWITHSUNDEEP
google-sheets
Raghu
Raghu

Reputation: 1

Month function on googlesheets

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?

enter image description here

Upvotes: 0

Views: 40

Answers (1)

ADW
ADW

Reputation: 4247

You could try

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

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

Upvotes: 2

Related Questions