0

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

Here is a sample spreadsheet.

6
  • Works perfectly for me: i.stack.imgur.com/ctllH.png
    – Kos
    Jan 12, 2018 at 15:04
  • @Kos, weird. Please, could you tell me which OS, browser and system language you are using?
    – gabra
    Jan 12, 2018 at 15:45
  • Note that error message you got refers to different text format: "01-Setembro-01"
    – Kos
    Jan 12, 2018 at 15:48
  • @kos, the same happens with "01/Setembro/01". I will edit my question
    – gabra
    Jan 12, 2018 at 22:07
  • Here's sample spreadsheet I have noticed that sometimes it really gives error on same input, what I did to fix it: delete month name and drag month down to the cell
    – Kos
    Jan 12, 2018 at 22:23

1 Answer 1

1

You can use google translate built in function on sheets to convert September to english and use is that way -

=MONTH("01/"&GOOGLETRANSLATE(A1,"pt","en")&"/01")

enter image description here

3
  • Thanks for answering. But I am getting the same error. And now it happens for all months. Example spreadsheet
    – gabra
    Jan 19, 2018 at 23:09
  • What locale is your spreadsheet set fOr? Jan 19, 2018 at 23:15
  • Brasil. If I change it to the United States, the function works.
    – gabra
    Jan 20, 2018 at 22:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.