Manuals/calci/EOMONTH

EOMONTH(sd,m)

• where $sd$ is the starting date
• $m$ is the number of months that can be positive or negative.

EOMONTH() displays the serial number of the last day of the month before or after the specified number of months.

Description

EOMONTH(sd,m)

For Example,

EOMONTH("12/12/2013",1) returns Fri JAN 31 2014 17:29:48 GMT-0500(Eastern Standard Time)

This is the last day of the month, one month after the starting date $sd$.

• The function initially calculates the actual month by adding or subtracting the specified month from the starting date, and displays the last day of that month.
• Argument $sd$ should be entered in a date format, using DATE function, or as a result of any other function.
• If $sd$ is not a valid date, Calci displays #NULL error message.
• If $sd$ plus number of months $m$ mentioned, is not a valid date, Calci displays #NULL error message.
• The number of months $m$ can be positive or negative.
• Positive value of $m$ adds up the months from $sd$ and displays future date, while negative value of $m$ subtracts the months from $sd$ and displays past date.
• If $m$ is a non-integer, it is truncated.
• If $m$ is omitted, Calci assumes it to be '0' i.e. last day of the same specified month is displayed.

Examples

1/1/2010
12/12/2013
4/20/2008

=EOMONTH(A1,6) :Calculates last day of the month, six months after 1/1/2010. Returns Sat Jul 31 2010 17:39:30 GMT-0400(Eastern Daylight Time) as a result.
=EOMONTH(B1,-1) :Calculates last day of the month, one month before 12/12/2013. Returns Sat Nov 30 2013 17:42:39 EST-0500(Eastern Standard Time) as a result.
=EOMONTH(C1,3.5) :Calculates last day of the month, three months after 4/20/2008. Returns Thu Jul 31 2008 17:43:43 GMT-0400(Eastern Daylight Time) as a result.

See Also

• DATE
• DAYS360
• DATEVALUE

References