Difference between revisions of "Manuals/calci/EOMONTH"

From ZCubes Wiki
Jump to navigation Jump to search
 
(12 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,
Line 14: Line 12:
 
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 <math>sd</math>.
+
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> plus 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="4SpaceContent" class="zcontent" align="left">
 
  
−
{| id="TABLE3" class="SpreadSheet blue"
+
1. EOMONTH("1/1/2010",6) = 07/31/2010
−
|- class="even"
+
 
−
| class="sshl_f" | 1/1/2010
+
2. EOMONTH("2/12/2013",-1) = 01/31/2013
−
| class="sshl_f" |
+
 
−
| class="sshl_f" |
+
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
  
−
|- class="odd"
+
9. EOMONTH(TODAY(), -2.5) = 12/16/2021
−
| class="sshl_f" | 12/12/2013
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
  
−
|- class="even"
+
==Related Videos==
−
| class="sshl_f" | 4/20/2008
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|}
 
  
−
=EOMONTH(A1,6) :Calculates last day of the month, 6 months after 1/1/2010. Returns ''Sat Jul 31 2010 17:39:30 GMT-0400(Eastern Daylight Time)''.
+
{{#ev:youtube|XqJJ1S8ENs4|280|center|EOMONTH}}
−
=EOMONTH(B1,-1) :Calculates last day of the month, 1 month before 12/12/2013. Returns ''Sat Nov 30 2013 17:42:39 EST-0500(Eastern Standard Time)''.
 
−
=EOMONTH(C1,3.5) :Calculates last day of the month, 3 months after 4/20/2008. Returns ''Thu Jul 31 2008 17:43:43 GMT-0400(Eastern Daylight Time)''.
 
  
−
==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 03:40, 23 February 2022

EOMONTH (start_date,months)


  • where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} is the starting date
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} should be entered in a date format, using DATE function, or as a result of any other function.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} is not a valid date, Calci displays #NULL error message.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} plus number of months Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} mentioned, is not a valid date, Calci displays #NULL error message.
  • The number of months Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} can be positive or negative.
  • Positive value of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} adds up the months from Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} and displays future date, while negative value of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} subtracts the months from Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} and displays past date.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} is a non-integer, it is truncated.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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]".

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"