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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(9 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE: MONTHS function}}
 +
{{Documentation/CalcFunc DateTimeTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_WEEKNUM_ADD_function
 +
|NextPage=Documentation/How_Tos/Calc:_YEARS_function
 +
}}__NOTOC__
  
 
== MONTHS ==
 
== MONTHS ==
Line 30: Line 35:
 
: returns <tt>'''1'''</tt>.  Even though the dates are just one day apart, they lie in different months.
 
: returns <tt>'''1'''</tt>.  Even though the dates are just one day apart, they lie in different months.
  
−
=== See also: ===
+
=== Issues: ===
−
'''[[Documentation/How_Tos/Calc: DAYS function|DAYS]]''',
+
* This function is not available in Excel.
−
'''[[Documentation/How_Tos/Calc: WEEKS function|WEEKS]]''',
+
−
'''[[Documentation/How_Tos/Calc: YEARS function|YEARS]]'''
+
  
−
'''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]'''
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: DAYS function|DAYS]]
 +
* [[Documentation/How_Tos/Calc: WEEKS function|WEEKS]]
 +
* [[Documentation/How_Tos/Calc: YEARS function|YEARS]]
  
−
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]'''
+
* [[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]
  
−
=== Issues: ===
+
* [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]
−
* This function is not available in Excel.
+
 
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Date and Time functions]]

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