Manuals/calci/EOMONTH

EOMONTH (start_date,months)

where $start-date$ is the starting date
is the number of months that can be positive or negative.
- EOMONTH(), returns the serial number of the last day of the month before or after a specified number of months.

Description

EOMONTH (start_date,months)

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 $start-date$ .

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 $start-date$ should be entered in a date format, using DATE function, or as a result of any other function.
If $start-date$ is not a valid date, Calci displays #NULL error message.
If $start-date$ plus number of months $months$ mentioned, is not a valid date, Calci displays #NULL error message.
The number of months $months$ can be positive or negative.
Positive value of $months$ adds up the months from $start-date$ and displays future date, while negative value of $months$ subtracts the months from $start-date$ and displays past date.
If $months$ is a non-integer, it is truncated.
If $months$ is omitted, Calci assumes it to be '0' i.e. last day of the same specified month is displayed.
We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".

1. EOMONTH("1/1/2010",6) = 07/31/2010

2. EOMONTH("2/12/2013",-1) = 01/31/2013

3. EOMONTH(NOW(),0) = 02/28/2022

4. EOMONTH(NOW(),0,"week") = 02/26/2022

5. EOMONTH("2001-01-01",0,"week") = 01/06/2001

6. EOMONTH(TODAY(), -2.3) = 12/22/2021

7. EOMONTH(TODAY(), -2) = 12/31/2021

8. EOMONTH(TODAY(), 2.5) = 05/15/2022

9. EOMONTH(TODAY(), -2.5) = 12/16/2021