EOMONTH

This function calculates the last day of the month (end of month) that is the indicated number of months before or after the starting date. Typically, this function is used to evaluate expiry dates, due dates and other dates that are supposed to land at the end of a month.

Syntax

EOMONTH(startdate,months)

Arguments

This function has these arguments:

Argument	Description
startdate	Starting date
months	Number of months before (negative) or after (positive) the starting date; if not an integer, the number is truncated

Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4).

Data Types

Accepts numeric, string, or DateTime object data for the startdate argument and numeric data for the months argument. Returns the serial number for the last day of the month.

Examples

EOMONTH(A3,6)

EOMONTH(R3C1,-4)

EOMONTH("2019/02/13",2) gives the result 43585

Version Available

This function is available in product version 1.0 or later.

Note: If a user uses LegacyBehaviors.CalculationEngine, EOMONTH function will return the DateTime object instead of the serial numeric value. For more details, please refer to breaking changes for legacy behaviors.

Syntax

Arguments

Data Types

Examples

Version Available

See Also