|
<< Click to Display Table of Contents >> EOMONTH (end of month in n months) |
Syntax:
EOMONTH(StartDate, m)
Description:
This returns the last day of the month that is m months before/after StartDate.
The argument StartDate must be a valid date value, as the function will return the #VALUE! error value otherwise.
m is the number of months.
If m is zero, the last day of the same month will be returned.
If m is positive, the program calculates a date that is m months after the StartDate.
If m is negative, the program calculates a date that is m months before the StartDate.
m should be an integer. If this is not the case, PlanMaker automatically removes the decimal places.
Example:
EOMONTH("09/25/2018", 0) returns 09/30/2018
EOMONTH("09/25/2018", 1) returns 10/31/2018
EOMONTH("09/25/2018", -1) returns 08/31/2018
If cell A1 contains the date value 9/25/2018, then EOMONTH(A1, 0) returns 9/30/2018
See also: