Difference between revisions of "Manuals/calci/EOMONTH"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | =EOMONTH(sd,m)= | |
| − | + | *where <math>sd</math> is the starting date | |
| + | *<math>m</math> 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. | |
| − | </ | + | *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 <math>sd</math> should be entered in a date format, using DATE function, or as a result of any other function. |
| − | < | + | *If <math>sd</math> is not a valid date, Calci displays #NULL error message. |
| + | *If <math>sd</math> with number of months <math>m</math> mentioned, is not a valid date, Calci displays #NULL error message. | ||
| + | *The number of months <math>m</math> can be positive or negative. | ||
| + | *Positive value of <math>m</math> adds up the months from <math>sd</math> and displays future date, while negative value of <math>m</math> subtracts the months from <math>sd</math> and displays past date. | ||
| + | *If <math>m</math> is a non-integer, it is truncated. | ||
| + | *If <math>m</math> is omitted, Calci assumes it to be '0' i.e. last day of the same specified month is displayed. | ||
| − | + | == Examples == | |
| − | + | <div id="2SpaceContent" class="zcontent" align="left"> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | <div id=" | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| + | | class=" " | 1/1/2010 | ||
| + | | class=" " | | ||
| class=" " | | | class=" " | | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | |
| − | | class=" " | | + | | class=" " | 12/12/2013 |
| − | | class=" | + | | class=" " | |
| − | + | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class=" " | |
| − | |||
| class=" " | | | class=" " | | ||
| − | | class=" | + | | class=" " | 4/20/2008 |
| − | + | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class=" " | | |
| − | |||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
| + | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|} | |} | ||
| − | + | =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== | ||
| + | |||
| + | *[[Manuals/calci/DATE | DATE ]] | ||
| + | *[[Manuals/calci/DAYS360 | DAYS360]] | ||
| + | *[[Manuals/calci/DATEVALUE | DATEVALUE]] | ||
| + | |||
| + | ==References== | ||
Revision as of 18:04, 17 December 2013
EOMONTH(sd,m)
- where is the starting date
- is the number of months that can be positive or negative.
is the starting date
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.
- 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 should be entered in a date format, using DATE function, or as a result of any other function.
- If is not a valid date, Calci displays #NULL error message.
- If with number of months mentioned, is not a valid date, Calci displays #NULL error message.
- The number of months can be positive or negative.
- Positive value of adds up the months from and displays future date, while negative value of subtracts the months from and displays past date.
- If is a non-integer, it is truncated.
- If 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.