Can't get number of month for a specific month in the Portuguese version of Google Sheets

by gabra   Last Updated January 12, 2018 15:03 PM

I am obtaining the number of months for the Portuguese names of the months using Google Sheets. For most months, the formula below works:

=MONTH("01/"&A1&"/01")

Except for Setembro (in English, September). The error returned is that

Função MONTH parâmetro 1 espera os valores número, mas "01-Setembro-01" é na verdade texto e não pode ser forçado para número.

Which translated is:

The parameter 1 of the MONTH function expects numerical values, but "01-Setembro-01" is in fact text and can't be forced to number.

enter image description here



Related Questions