Difference between revisions of "Documentation/How Tos/Calc: MONTHS function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
Line 1: Line 1:
−
 
+
{{DISPLAYTITLE: MONTHS function}}
−
{{Documentation/MasterTOC
+
{{Documentation/CalcFunc DateTimeTOC
−
|bookid=1234'''
+
|ShowPrevNext=block
−
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+
|PrevPage=Documentation/How_Tos/Calc:_WEEKNUM_ADD_function
−
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div  style="font-size: 140%;">Date & Time Functions]]
+
|NextPage=Documentation/How_Tos/Calc:_YEARS_function
−
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_YEARS_function
+
}}__NOTOC__
−
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_WEEKNUM_ADD_function
+
−
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Database_functions
+
−
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Financial_functions
+
−
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
+
−
* [[Documentation/How_Tos/Calc:_TODAY_function|<div style="font-size: 120%;">Today]]
+
−
* [[Documentation/How_Tos/Calc:_NOW_function|<div style="font-size: 120%;">Now]]
+
−
* [[Documentation/How_Tos/Calc:_YEAR_function|<div style="font-size: 120%;">Year]]
+
−
* [[Documentation/How_Tos/Calc:_MONTH_function|<div style="font-size: 120%;">Month]]
+
−
* [[Documentation/How_Tos/Calc:_DAY_function|<div style="font-size: 120%;">Day]]
+
−
* [[Documentation/How_Tos/Calc:_WEEKDAY_function|<div style="font-size: 120%;">Weekday]]
+
−
* [[Documentation/How_Tos/Calc:_HOUR_function|<div style="font-size: 120%;">Hour]]
+
−
* [[Documentation/How_Tos/Calc:_MINUTE_function|<div style="font-size: 120%;">Minute]]
+
−
* [[Documentation/How_Tos/Calc:_SECOND_function|<div style="font-size: 120%;">Second]]
+
−
* [[Documentation/How_Tos/Calc:_DATE_function|<div style="font-size: 120%;">Date]]
+
−
* [[Documentation/How_Tos/Calc:_DATEVALUE_function|<div style="font-size: 120%;">Datevalue]]
+
−
* [[Documentation/How_Tos/Calc:_TIME_function|<div style="font-size: 120%;">Time]]
+
−
* [[Documentation/How_Tos/Calc:_TIMEVALUE_function|<div style="font-size: 120%;">Timevalue]]
+
−
* [[Documentation/How_Tos/Calc:_EOMONTH_function|<div style="font-size: 120%;">Eomonth]]
+
−
* [[Documentation/How_Tos/Calc:_EDATE_function|<div style="font-size: 120%;">Edate]]
+
−
* [[Documentation/How_Tos/Calc:_WORKDAY_function|<div style="font-size: 120%;">Workday]]
+
−
* [[Documentation/How_Tos/Calc:_NETWORKDAYS_function|<div style="font-size: 120%;">Networkdays]]
+
−
* [[Documentation/How_Tos/Calc:_DAYS_function|<div style="font-size: 120%;">Days]]
+
−
* [[Documentation/How_Tos/Calc:_DAYS360_function|<div style="font-size: 120%;">Days360]]
+
−
* [[Documentation/How_Tos/Calc:_DAYSINMONTH_function|<div style="font-size: 120%;">Daysinmonth]]
+
−
* [[Documentation/How_Tos/Calc:_DAYSINYEAR_function|<div style="font-size: 120%;">Daysinyear]]
+
−
* [[Documentation/How_Tos/Calc:_WEEKS_function|<div style="font-size: 120%;">Weeks]]
+
−
* [[Documentation/How_Tos/Calc:_WEEKSINYEAR_function|<div style="font-size: 120%;">Weeksinyear]]
+
−
* [[Documentation/How_Tos/Calc:_WEEKNUM_function|<div style="font-size: 120%;">Weeknum]]
+
−
* [[Documentation/How_Tos/Calc:_WEEKNUM_ADD_function|<div style="font-size: 120%;">Weeknum_add]]
+
−
* [[Documentation/How_Tos/Calc:_MONTHS_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Months]]
+
−
* [[Documentation/How_Tos/Calc:_YEARS_function|<div style="font-size: 120%;">Years]]
+
−
* [[Documentation/How_Tos/Calc:_ISLEAPYEAR_function|<div style="font-size: 120%;">Isleapyear]]
+
−
* [[Documentation/How_Tos/Calc:_EASTERSUNDAY_function|<div style="font-size: 120%;">Eastersunday]]
+
−
* [[Documentation/How_Tos/Calc:_YEARFRAC_function|<div style="font-size: 120%;">Yearfrac]]
+
−
}}__TOC__
+
−
 
+
  
 
== MONTHS ==
 
== MONTHS ==

Latest revision as of 14:06, 30 January 2024



MONTHS

Returns the number of months between two dates.

This function is only available if the Analysis AddIn is installed.

Syntax:

MONTHS(startdate; enddate; mode)

if mode is 0, MONTHS returns the number of whole months between startdate and enddate, day of the month to day of the month (see examples).
if mode is 1, MONTHS identifies the month that startdate and enddate each lie in, and returns the difference between those months. In other words it returns MONTH(enddate) - MONTH(startdate) + 12 * (YEAR(enddate) - YEAR(startdate)).
If startdate is after enddate the result will be negative.

Example:

MONTHS("2010-04-03"; "2011-06-17"; 0)

returns 14, the number of months between 3 April 2010 and 17 June 2011.

MONTHS("2010-03-31"; "2010-04-30"; 0)

returns 0. 31 March to 30 April is not considered a whole month, even though they are both the last day of their months.

MONTHS("2010-03-31"; "2010-06-30"; 0)

returns 2. Even though both dates are the last day of their months, the last month is not counted, because the day is less than 31.

MONTHS("2010-04-03"; "2011-06-17"; 1)

returns 14, the number of months between April 2010 and June 2011.

MONTHS("2010-03-31"; "2010-04-01"; 1)

returns 1. Even though the dates are just one day apart, they lie in different months.

Issues:

  • This function is not available in Excel.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_MONTHS_function&oldid=259709"
Views
Personal tools
Navigation
Tools