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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Bot: Adding Category: Documentation)
m
 
(5 intermediate revisions by 4 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{DISPLAYTITLE: DAYS function}}
 +
{{Documentation/CalcFunc DateTimeTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_NETWORKDAYS_function
 +
|NextPage=Documentation/How_Tos/Calc:_DAYS360_function
 +
}}__NOTOC__
  
 
== DAYS ==
 
== DAYS ==
Line 22: Line 27:
 
* <tt>'''DAYS'''</tt> really does return <tt>'''enddate - startdate'''</tt>; thus if either date has a time component (for example "2008-01-03T15:15"), the number of days returned may not be integer. To ensure an integer result, consider <tt>'''INT(DAYS())'''</tt>.
 
* <tt>'''DAYS'''</tt> really does return <tt>'''enddate - startdate'''</tt>; thus if either date has a time component (for example "2008-01-03T15:15"), the number of days returned may not be integer. To ensure an integer result, consider <tt>'''INT(DAYS())'''</tt>.
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: DAYS360 function|DAYS360]]
 
* [[Documentation/How_Tos/Calc: DAYS360 function|DAYS360]]
 
* [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]]
 
* [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]]
Line 35: Line 40:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
[[Category: Documentation]]
+
[[Category: Documentation/Reference/Calc/Date and Time functions]]

Latest revision as of 13:58, 30 January 2024



DAYS

Returns the number of days between two dates

Syntax:

DAYS(enddate; startdate)

startdate and enddate may be dates as numbers or text (which is converted to number form).
DAYS returns enddate - startdate. The result may be negative.

Example:

DAYS("2008-03-03"; "2008-03-01")

returns 2, the number of days between 1March08 and 3March08.

DAYS(A1; A2)

where cell A1 contains the date 2008-06-09 and A2 contains 2008-06-02 returns 7.

Issues:

  • Note that DAYS does not count the first day of the period, but NETWORKDAYS does.
  • DAYS is not portable to Excel.
  • DAYS really does return enddate - startdate; thus if either date has a time component (for example "2008-01-03T15:15"), the number of days returned may not be integer. To ensure an integer result, consider INT(DAYS()).



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