Difference between revisions of "Manuals/calci/EOMONTH"

From ZCubes Wiki
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user 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]".
 
*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="even"
+
2. EOMONTH("2/12/2013",-1) = 01/31/2013
−
| class="sshl_f" |
+
 
−
| class="sshl_f" | A
+
3. EOMONTH(NOW(),0) = 02/28/2022
−
| class="sshl_f" | B
+
 
−
| class="sshl_f" | C
+
4. EOMONTH(NOW(),0,"week") = 02/26/2022
 +
 
 +
5. EOMONTH("2001-01-01",0,"week") = 01/06/2001
  
−
|- class="odd"
+
6. EOMONTH(TODAY(), -2.3) = 12/22/2021
−
| class="sshl_f" | 1
 
−
| class="sshl_f" | 1/1/2010
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
  
−
|- class="even"
+
7. EOMONTH(TODAY(), -2) = 12/31/2021
−
| class="sshl_f" | 2
 
−
| class="sshl_f" | 12/12/2013
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
  
−
|- class="odd"
+
8. EOMONTH(TODAY(), 2.5) = 05/15/2022
−
| class="sshl_f" | 3
 
−
| 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)'''.
+
9. EOMONTH(TODAY(), -2.5) = 12/16/2021
−
=EOMONTH(A2,-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(A3,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)'''.
 
  
 
==Related Videos==
 
==Related Videos==

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"