Manuals/calci/EOMONTH

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 $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

• DATE
• EDATE
• DATEVALUE

References

• Months
• Date Time Group

• List of Main Z Functions

• Z3 home