Rješavač

The result is a date which is a number of months away from the start date. Only months are considered; days are not used for calculation.

Sintaksa

EOMONTH(Start_date; Months)

StartDate is a date.

Months is the number of months before (negative) or after (positive) the start date.

Primjer

What date is one month prior to 2001-03-31?

=EOMONTH("14/09/2001"; 6) vraca 31/03/2002.