Difference between revisions of "Manuals/calci/EOMONTH"

From ZCubes Wiki
Jump to navigation Jump to search
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
=EOMONTH(sd,m)=
+
<div style="font-size:30px">'''EOMONTH (start_date,months)'''</div><br/>
−
 
+
*where <math>start-date</math> is the starting date
−
*where <math>sd</math> is the starting date
+
*<math>months</math> is the number of months that can be positive or negative.
−
*<math>m</math> 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.
−
 
 
−
EOMONTH() displays the serial number of the last day of the month before or after the specified number of months.
 
  
 
== Description ==
 
== Description ==
  
−
EOMONTH(sd,m)
+
EOMONTH (start_date,months)
  
 
For Example,
 
For Example,
  
−
EOMONTH("12/12/2013",1) ''returns Fri JAN 31 2014 17:29:48 GMT-0500(Eastern Standard Time)''  
+
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.
+
This is the last day of the month, one month after the starting date <math>start-date</math>.
  
 
*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.
 
*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.
+
*Argument <math>start-date</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>start-date</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.
+
*If <math>start-date</math> plus number of months <math>months</math> mentioned, is not a valid date, Calci displays #NULL error message.
−
*The number of months <math>m</math> can be positive or negative.
+
*The number of months <math>months</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.
+
*Positive value of <math>months</math> adds up the months from <math>start-date</math> and displays future date, while negative value of <math>months</math> subtracts the months from <math>start-date</math> and displays past date.
−
*If <math>m</math> is a non-integer, it is truncated.
+
*If <math>months</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.
+
*If <math>months</math> 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]".
  
 
== Examples ==
 
== Examples ==
−
<div id="2SpaceContent" class="zcontent" align="left">
 
  
−
{| id="TABLE3" class="SpreadSheet blue"
+
1. EOMONTH("1/1/2010",6) = 07/31/2010
−
|- class="even"
+
 
−
| class=" " | 1/1/2010
+
2. EOMONTH("2/12/2013",-1) = 01/31/2013
−
| class=" " |
+
 
−
| class=" " |
+
3. EOMONTH(NOW(),0) = 02/28/2022
 +
 
 +
4. EOMONTH(NOW(),0,"week") = 02/26/2022
  
−
|- class="odd"
+
5. EOMONTH("2001-01-01",0,"week") = 01/06/2001
−
| class="sshl_f" |
 
−
| class=" " | 12/12/2013
 
−
| class=" " |
 
  
−
|- class="even"
+
6. EOMONTH(TODAY(), -2.3) = 12/22/2021
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " | 4/20/2008
 
  
−
|- class="odd"
+
7. EOMONTH(TODAY(), -2) = 12/31/2021
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
  
−
|- class="even"
+
8. EOMONTH(TODAY(), 2.5) = 05/15/2022
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
  
−
|- class="odd"
+
9. EOMONTH(TODAY(), -2.5) = 12/16/2021
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
  
−
|}
+
==Related Videos==
  
−
=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.
+
{{#ev:youtube|XqJJ1S8ENs4|280|center|EOMONTH}}
−
=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==
+
== See Also ==
  
 
*[[Manuals/calci/DATE  | DATE ]]
 
*[[Manuals/calci/DATE  | DATE ]]
−
*[[Manuals/calci/DAYS360 | DAYS360]]
+
*[[Manuals/calci/EDATE | EDATE]]
 
*[[Manuals/calci/DATEVALUE  | DATEVALUE]]
 
*[[Manuals/calci/DATEVALUE  | DATEVALUE]]
  
−
==References==
+
== References ==
 +
 
 +
*[http://en.wikipedia.org/wiki/Month#Julian_and_Gregorian_calendars Months]
 +
*[http://en.wikipedia.org/wiki/Date-time_group Date Time Group]
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 02:40, 23 February 2022

EOMONTH (start_date,months)


  • where 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 .

  • 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 plus 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.
  • We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".

Examples

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

Related Videos

EOMONTH

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/EOMONTH&oldid=216899"