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=...") |
|||
| (15 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''EOMONTH (start_date,months)'''</div><br/> |
| + | *where <math>start-date</math> is the starting date | ||
| + | *<math>months</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. | ||
| − | + | == 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 <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. |
| − | - | + | *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>start-date</math> 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>months</math> can be positive or negative. | ||
| + | *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>months</math> is a non-integer, it is truncated. | ||
| + | *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 == | |
| − | + | 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== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | {{#ev:youtube|XqJJ1S8ENs4|280|center|EOMONTH}} | |
| − | + | ||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/DATE | DATE ]] | ||
| + | *[[Manuals/calci/EDATE | EDATE]] | ||
| + | *[[Manuals/calci/DATEVALUE | DATEVALUE]] | ||
| + | |||
| + | == 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 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.
is the starting date
is the number of months that can be positive or negative.
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
See Also
References