Google Sheets – EOMONTH Function Returns Parse Error

google sheets

Following Google Docs "Editors Help" I just tried out the function EOMONTH.

Unfortunately, every example I found there will result in an "Parse Error".
Example:

=EOMONTH(DATE(1969, 7, 20), 1)

The same happens with addressing specific cells like

=EOMONTH(A1, 1)

(A1 will contain a valid date)

What is wrong here?

UPDATE:

I'll provide an example-sheet here.

enter image description here
enter image description here

Best Answer

In (much of) Europe, formulas need to use semi-colons instead of commas.

So, instead of 

=EOMONTH(DATE(1969, 7, 20), 1)

use

=EOMONTH(DATE(1969; 7; 20); 1)

(I presume that this is because comma is a decimal separator for Europeans, while Americans use a period.)

The Google Support page for the EOMONTH function in German shows semi-colons, while the same page in English shows commas. (French is inconsistent, but Spanish and Italian help pages also use semi-colons.)

Related Topic