diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-12-28 13:52:39 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-12-29 11:22:16 +0100 |
| commit | efc2eba6081f95dbf83ea1776a563bbddaa13f68 (patch) | |
| tree | 8cbe1166f391d4b54dfbd0a5eec324644a0c373f /source | |
| parent | d3ef8cc77967993569abb0681c2ea66a9959c830 (diff) | |
tdf#127477 Incomplete description of date & time
functions
+ case of YEAR()
+ some refactoring
+ mention ODFF standard where it applies.
Change-Id: I91c2a7f8cc799d99af8380f228678ef0e49bdd83
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/85926
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
29 files changed, 218 insertions, 291 deletions
diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp index 3f0acce19c..2e1fd17996 100644 --- a/source/text/scalc/01/04060102.xhp +++ b/source/text/scalc/01/04060102.xhp @@ -26,15 +26,12 @@ </meta> <body> - <bookmark xml-lang="en-US" branch="index" id="bm_id3154536"> <bookmark_value>date and time functions</bookmark_value> <bookmark_value>functions; date & time</bookmark_value> <bookmark_value>Function Wizard; date & time</bookmark_value> </bookmark> - - -<h1 id="hd_id3154536">Date & Time Functions</h1> +<h1 id="hd_id3154536"><variable id="h1">Date & Time Functions</variable></h1> <paragraph id="par_id3153973" role="paragraph" xml-lang="en-US"><variable id="datumzeittext">These spreadsheet functions are used for inserting and editing dates and times. </variable></paragraph> <section id="howtoget"> @@ -46,6 +43,7 @@ </section> <paragraph id="par_id3150437" role="paragraph" xml-lang="en-US">$[officename] internally handles a date/time value as a numerical value. If you assign the numbering format "Number" to a date or time value, it is converted to a number. For example, 01/01/2000 12:00 PM, converts to 36526.5. The value preceding the decimal point corresponds to the date; the value following the decimal point corresponds to the time. If you do not want to see this type of numerical date or time representation, change the number format (date or time) accordingly. To do this, select the cell containing the date or time value, call its context menu and select <emph>Format Cells</emph>. The <emph>Numbers</emph> tab page contains the functions for defining the number format.</paragraph> +<section id="datebase"> <h2 id="hd_id2408825">Date base for day zero</h2> <paragraph id="par_id9988402" role="paragraph" xml-lang="en-US">Dates are calculated as offsets from a starting day zero. You can set the day zero to be one of the following:</paragraph> @@ -83,7 +81,7 @@ </tablecell> </tablerow> </table> - +</section> <paragraph id="par_id791039" role="paragraph" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph> </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Calculate</emph> to select the date base.</paragraph> <warning id="par_id1953489">When you copy and paste cells containing date values between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!</warning> @@ -101,124 +99,41 @@ <note id="par_id651547654187646">Time zone information is not used in Date and Time functions and cells.</note> <h2 id="par_idN1067A">Functions</h2> -<sort order="asc"> - -<section id="workday"> -<paragraph id="par_idN10683" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.xhp#workday"/> </paragraph> -</section> - -<section id="yearfrac"> -<paragraph id="par_id5189062" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_yearfrac.xhp#yearfrac"/> </paragraph> -</section> +<section id="datetimefunctions"> + <paragraph role="paragraph" id="par_id31577531529079" localize="false"><embedvar href="text/scalc/01/04060102.xhp#h1" markup="ignore"/></paragraph> -<section id="date"> <paragraph id="par_id6854457" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_date.xhp#date"/> </paragraph> -</section> - -<section id="datedif"> <paragraph id="par_id6354457" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_datedif.xhp#datedif"/> </paragraph> -</section> - -<section id="datevalue"> <paragraph id="par_id3372295" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_datevalue.xhp#datevalue"/> </paragraph> -</section> - -<section id="edate"> +<paragraph id="par_id5375835" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_day.xhp#day"/> </paragraph> +<paragraph id="par_id1208838" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days.xhp#days"/> </paragraph> +<paragraph id="par_id7679982" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days360.xhp#days360"/> </paragraph> +<paragraph id="par_id1074251" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eastersunday.xhp#eastersunday"/> </paragraph> <paragraph id="par_id5684377" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_edate.xhp#edate"/> </paragraph> -</section> - -<section id="today"> -<paragraph id="par_id7576525" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_today.xhp#today"/> </paragraph> -</section> - -<section id="year"> -<paragraph id="par_id641193" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_year.xhp#year"/> </paragraph> -</section> - -<section id="now"> -<paragraph id="par_id6501968" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_now.xhp#now"/> </paragraph> -</section> - -<section id="isoweeknum"> +<paragraph id="par_id1346781" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eomonth.xhp#eomonth"/> </paragraph> +<paragraph id="par_id224005" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_hour.xhp#hour"/> </paragraph> <paragraph id="par_id3886533" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_isoweeknum.xhp#isoweeknum"/> </paragraph> -</section> - -<section id="weeknum"> -<paragraph id="par_id3886532" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/> </paragraph> -</section> - -<section id="weeknum_ooo"> -<paragraph id="par_id3886534" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/> </paragraph> -</section> - -<section id="weeknumadd"> -<paragraph id="par_id614947" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/> </paragraph> -</section> - -<section id="minute"> <paragraph id="par_id3953062" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_minute.xhp#minute"/> </paragraph> -</section> - -<section id="month"> <paragraph id="par_id2579729" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_month.xhp#month"/> </paragraph> -</section> - -<section id="eomonth"> -<paragraph id="par_id1346781" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eomonth.xhp#eomonth"/> </paragraph> -</section> - -<section id="networkdays"> <paragraph id="par_id8951384" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_networkdays.xhp#networkdays"/> </paragraph> -</section> - -<section id="networkdaysintl"> <paragraph id="par_id231020162315043955" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/> </paragraph> -</section> - -<section id="workdaysintl"> -<paragraph id="par_id231020163315043955" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> </paragraph> -</section> - -<section id="eastersunday"> -<paragraph id="par_id1074251" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_eastersunday.xhp#eastersunday"/> </paragraph> -</section> - -<section id="second"> +<paragraph id="par_id6501968" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_now.xhp#now"/> </paragraph> <paragraph id="par_id372325" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_second.xhp#second"/> </paragraph> -</section> - -<section id="hour"> -<paragraph id="par_id224005" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_hour.xhp#hour"/> </paragraph> -</section> - -<section id="day"> -<paragraph id="par_id5375835" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_day.xhp#day"/> </paragraph> -</section> - -<section id="days"> -<paragraph id="par_id1208838" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days.xhp#days"/> </paragraph> -</section> - -<section id="days360"> -<paragraph id="par_id7679982" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_days360.xhp#days360"/> </paragraph> -</section> - -<section id="weekday"> -<paragraph id="par_id9172643" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weekday.xhp#weekday"/> </paragraph> -</section> - -<section id="time"> <paragraph id="par_id2354503" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_time.xhp#time"/> </paragraph> -</section> - -<section id="timevalue"> <paragraph id="par_id7765434" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_timevalue.xhp#timevalue"/> </paragraph> +<paragraph id="par_id7576525" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_today.xhp#today"/> </paragraph> +<paragraph id="par_id9172643" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weekday.xhp#weekday"/> </paragraph> +<paragraph id="par_id3886532" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum.xhp#weeknum"/> </paragraph> +<paragraph id="par_id614947" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknumadd.xhp#weeknumadd"/> </paragraph> +<paragraph id="par_id3886534" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo"/> </paragraph> +<paragraph id="par_idN10683" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.xhp#workday"/> </paragraph> +<paragraph id="par_id231020163315043955" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> </paragraph> +<paragraph id="par_id641193" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_year.xhp#year"/> </paragraph> +<paragraph id="par_id5189062" role="paragraph" localize="false" xml-lang="en-US"> <embedvar href="text/scalc/01/func_yearfrac.xhp#yearfrac"/> </paragraph> </section> -</sort> <section id="relatedtopics"> <embed href="text/scalc/01/04060100.xhp#drking"/> </section> </body> - </helpdocument> diff --git a/source/text/scalc/01/func_date.xhp b/source/text/scalc/01/func_date.xhp index 7ab7182e11..bb05e1f800 100644 --- a/source/text/scalc/01/func_date.xhp +++ b/source/text/scalc/01/func_date.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_datexml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">DATE</title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3155511"><bookmark_value>DATE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/><paragraph role="heading" id="hd_id3155511" xml-lang="en-US" level="2"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATUM" id="bm_id3149022" localize="false"/><h2 id="hd_id3155511"><variable id="date"><link href="text/scalc/01/func_date.xhp">DATE</link> +</variable></h2> <paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp hid="HID_FUNC_DATUM">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3150474" xml-lang="en-US">DATE(Year; Month; Day)</paragraph> <paragraph role="paragraph" id="par_id3152815" xml-lang="en-US"> @@ -47,5 +43,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3152589" xml-lang="en-US"> <item type="input">=DATE(00;1;31)</item> yields 1/31/00 if the cell format setting is MM/DD/YY.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_datedif.xhp b/source/text/scalc/01/func_datedif.xhp index 3d56e4a286..d6a1cb4650 100644 --- a/source/text/scalc/01/func_datedif.xhp +++ b/source/text/scalc/01/func_datedif.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -20,10 +17,11 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3155511"><bookmark_value>DATEDIF function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATEDIF" id="bm_id3149022" localize="false"/><paragraph role="heading" id="hd_id3155511" xml-lang="en-US" level="2"><variable id="datedif"><link href="text/scalc/01/func_datedif.xhp">DATEDIF</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATEDIF" id="bm_id3149022" localize="false"/><h2 id="hd_id3155511"><variable id="datedif"><link href="text/scalc/01/func_datedif.xhp">DATEDIF</link> +</variable></h2> <paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp hid="HID_FUNC_DATEDIF">This function returns the number of whole days, months or years between Start date and End date.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#3.6"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3150474" xml-lang="en-US">DATEDIF(Start date; End date; Interval)</paragraph> <paragraph role="paragraph" id="par_id3152815" xml-lang="en-US"> @@ -106,5 +104,8 @@ Birthday calculation. A man was born on 1974-04-17. Today is 2012-06-13.</paragr <item type="input">=DATEDIF("1974-04-17";"2012-06-13";"d")</item> yields 13937, he has been living for 13937 days.</paragraph> <paragraph role="paragraph" id="par_id3752589" xml-lang="en-US"> <item type="input">=DATEDIF("1974-04-17";DATE(2012;06;13);"yd")</item> yields 57, his birthday was 57 days ago.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_datevalue.xhp b/source/text/scalc/01/func_datevalue.xhp index 06d27a0947..ea24c23be6 100644 --- a/source/text/scalc/01/func_datevalue.xhp +++ b/source/text/scalc/01/func_datevalue.xhp @@ -30,11 +30,12 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3145621"><bookmark_value>DATEVALUE function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATWERT" id="bm_id3163820" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3145621" role="heading" level="2"><variable id="datevalue"><link href="text/scalc/01/func_datevalue.xhp">DATEVALUE</link> -</variable></paragraph> +<h2 id="hd_id3145621"><variable id="datevalue"><link href="text/scalc/01/func_datevalue.xhp">DATEVALUE</link> +</variable></h2> <paragraph xml-lang="en-US" id="par_id3145087" role="paragraph"><ahelp hid="HID_FUNC_DATWERT">Returns the internal date number for text in quotes.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id3149281" role="paragraph">The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates.</paragraph> <paragraph xml-lang="en-US" id="par_id0119200903491982" role="paragraph">If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion.</paragraph> + <embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149268" role="code">DATEVALUE("Text")</paragraph> <paragraph xml-lang="en-US" id="par_id3154819" role="paragraph"> @@ -44,5 +45,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3155841" role="paragraph"> <item type="input">=DATEVALUE("1954-07-20")</item> yields 19925.</paragraph> + <section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_day.xhp b/source/text/scalc/01/func_day.xhp index c9f2c07e8f..33804020ef 100644 --- a/source/text/scalc/01/func_day.xhp +++ b/source/text/scalc/01/func_day.xhp @@ -1,5 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - <!-- * This file is part of the LibreOffice project. * @@ -27,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3147317"><bookmark_value>DAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><paragraph role="heading" id="hd_id3147317" xml-lang="en-US" level="2"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAG" id="bm_id3151283" localize="false"/><h2 id="hd_id3147317"><variable id="day"><link href="text/scalc/01/func_day.xhp">DAY</link> +</variable></h2> <paragraph role="paragraph" id="par_id3147584" xml-lang="en-US"><ahelp hid="HID_FUNC_TAG">Returns the day of given date value.</ahelp> The day is returned as an integer between 1 and 31. You can also enter a negative date/time value.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3149430" xml-lang="en-US">DAY(Number)</paragraph> <paragraph role="paragraph" id="par_id3149443" xml-lang="en-US"><emph>Number</emph> is the internal date number.</paragraph> @@ -39,5 +39,8 @@ <paragraph role="paragraph" id="par_id3151200" xml-lang="en-US"><item type="input">=DAY(1)</item> returns 31 (since $[officename] starts counting at zero from December 30, 1899)</paragraph> <paragraph role="paragraph" id="par_id3154130" xml-lang="en-US"><item type="input">=DAY(NOW())</item> returns the current day.</paragraph> <paragraph role="paragraph" id="par_id3159190" xml-lang="en-US"><item type="input">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the date value might get formatted differently after you press Enter).</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_days.xhp b/source/text/scalc/01/func_days.xhp index bb002c1a4f..fb50701a76 100644 --- a/source/text/scalc/01/func_days.xhp +++ b/source/text/scalc/01/func_days.xhp @@ -26,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3151328"><bookmark_value>DAYS function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/><paragraph role="heading" id="hd_id3151328" xml-lang="en-US" level="2"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/><h2 id="hd_id3151328"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link> +</variable></h2> <paragraph role="paragraph" id="par_id3155139" xml-lang="en-US"><ahelp hid="HID_FUNC_TAGE">Calculates the difference between two date values.</ahelp> The result returns the number of days between the two days.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3149578" xml-lang="en-US">DAYS(Date2; Date1)</paragraph> <paragraph role="paragraph" id="par_id3151376" xml-lang="en-US"> @@ -38,5 +39,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3159101" xml-lang="en-US"><item type="input">=DAYS(NOW();"2010-01-01"))</item> returns the number of days from January 1, 2010 until today.</paragraph> <paragraph role="paragraph" id="par_id3163720" xml-lang="en-US"><item type="input">=DAYS("1990-10-10";"1980-10-10")</item> returns 3652 days.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_days360.xhp b/source/text/scalc/01/func_days360.xhp index 15d822e909..22f5a3e5ac 100644 --- a/source/text/scalc/01/func_days360.xhp +++ b/source/text/scalc/01/func_days360.xhp @@ -26,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3148555"><bookmark_value>DAYS360 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE360" id="bm_id3155906" localize="false"/><paragraph role="heading" id="hd_id3148555" xml-lang="en-US" level="2"><variable id="days360"><link href="text/scalc/01/func_days360.xhp">DAYS360</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE360" id="bm_id3155906" localize="false"/><h2 id="hd_id3148555"><variable id="days360"><link href="text/scalc/01/func_days360.xhp">DAYS360</link> +</variable></h2> <paragraph role="paragraph" id="par_id3156032" xml-lang="en-US"><ahelp hid="HID_FUNC_TAGE360">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3155313" xml-lang="en-US">DAYS360("Date1"; "Date2"; Type)</paragraph> <paragraph role="paragraph" id="par_id3145263" xml-lang="en-US">If <emph>Date2</emph> is earlier than <emph>Date1</emph>, the function will return a negative number.</paragraph> @@ -37,5 +38,8 @@ <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3156348" xml-lang="en-US"><item type="input">=DAYS360("2000-01-01";NOW())</item> returns the number of interest days from January 1, 2000 until today.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_eastersunday.xhp b/source/text/scalc/01/func_eastersunday.xhp index 9da7e92bcf..5cb4fe7def 100644 --- a/source/text/scalc/01/func_eastersunday.xhp +++ b/source/text/scalc/01/func_eastersunday.xhp @@ -26,8 +26,8 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3152960"><bookmark_value>EASTERSUNDAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OSTERSONNTAG" id="bm_id3156270" localize="false"/><paragraph role="heading" id="hd_id3152960" xml-lang="en-US" level="2"><variable id="eastersunday"><link href="text/scalc/01/func_eastersunday.xhp">EASTERSUNDAY</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OSTERSONNTAG" id="bm_id3156270" localize="false"/><h2 id="hd_id3152960"><variable id="eastersunday"><link href="text/scalc/01/func_eastersunday.xhp">EASTERSUNDAY</link> +</variable></h2> <paragraph role="paragraph" id="par_id3154570" xml-lang="en-US"><ahelp hid="HID_FUNC_OSTERSONNTAG">Returns the date of Easter Sunday for the entered year.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id2113711" xml-lang="en-US">EASTERSUNDAY(Year)</paragraph> @@ -40,5 +40,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3154472" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)</item> returns 2000-04-23.</paragraph> <paragraph role="paragraph" id="par_id3150940" xml-lang="en-US"><item type="input">=EASTERSUNDAY(2000)+49</item> returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_edate.xhp b/source/text/scalc/01/func_edate.xhp index 8cc6846499..14b050236f 100644 --- a/source/text/scalc/01/func_edate.xhp +++ b/source/text/scalc/01/func_edate.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_edatexml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">EDATE</title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3151184"><bookmark_value>EDATE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/><paragraph role="heading" id="hd_id3151184" xml-lang="en-US" level="2"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EDATE" id="bm_id3150761" localize="false"/><h2 id="hd_id3151184"><variable id="edate"><link href="text/scalc/01/func_edate.xhp">EDATE</link> +</variable></h2> <paragraph role="paragraph" id="par_id3150880" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_EDATE">The result is a date which is a number of <emph>months</emph> away from the <emph>start date</emph>. Only months are considered; days are not used for calculation.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3153212" xml-lang="en-US">EDATE(StartDate; Months)</paragraph> <paragraph role="paragraph" id="par_id3146860" xml-lang="en-US"> @@ -46,5 +42,8 @@ <paragraph role="paragraph" id="par_id3155845" xml-lang="en-US">What date is one month prior to 2001-03-31?</paragraph> <paragraph role="paragraph" id="par_id3155999" xml-lang="en-US"> <item type="input">=EDATE("2001-03-31";-1)</item> returns the serial number 36950. Formatted as a date, this is 2001-02-28.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_eomonth.xhp b/source/text/scalc/01/func_eomonth.xhp index 19f98584be..186c4e9488 100644 --- a/source/text/scalc/01/func_eomonth.xhp +++ b/source/text/scalc/01/func_eomonth.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_eomonthxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">EOMONTH</title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150991"><bookmark_value>EOMONTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/><paragraph role="heading" id="hd_id3150991" xml-lang="en-US" level="2"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EOMONTH" id="bm_id3158439" localize="false"/><h2 id="hd_id3150991"><variable id="eomonth"><link href="text/scalc/01/func_eomonth.xhp">EOMONTH</link> +</variable></h2> <paragraph role="paragraph" id="par_id3152766" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_EOMONTH">Returns the date of the last day of a month which falls months away from the start date.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3150351" xml-lang="en-US">EOMONTH(StartDate; Months)</paragraph> <paragraph role="paragraph" id="par_id3146787" xml-lang="en-US"> @@ -45,6 +41,8 @@ <paragraph role="paragraph" id="par_id3156143" xml-lang="en-US"><item type="input">=EOMONTH(DATE(2001;9;14);6)</item> returns the serial number 37346. Formatted as a date, this is 2002-03-31.</paragraph> <paragraph role="paragraph" id="par_id3156144" xml-lang="en-US"><item type="input">=EOMONTH("2001-09-14";6)</item> works as well. If the date is given as string, it has to be in ISO format.</paragraph> - +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_hour.xhp b/source/text/scalc/01/func_hour.xhp index d4409245e5..9936d29149 100644 --- a/source/text/scalc/01/func_hour.xhp +++ b/source/text/scalc/01/func_hour.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_hourxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">HOUR </title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154725"><bookmark_value>HOUR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/><paragraph role="heading" id="hd_id3154725" xml-lang="en-US" level="2"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STUNDE" id="bm_id3152469" localize="false"/><h2 id="hd_id3154725"><variable id="hour"><link href="text/scalc/01/func_hour.xhp">HOUR</link> +</variable></h2> <paragraph role="paragraph" id="par_id3149747" xml-lang="en-US"><ahelp hid="HID_FUNC_STUNDE">Returns the hour for a given time value.</ahelp> The hour is returned as an integer between 0 and 23.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3150637" xml-lang="en-US">HOUR(Number)</paragraph> <paragraph role="paragraph" id="par_id3147547" xml-lang="en-US"> @@ -43,7 +39,8 @@ <item type="input">=HOUR(NOW())</item> returns the current hour</paragraph> <paragraph role="paragraph" id="par_id3145152" xml-lang="en-US"> <item type="input">=HOUR(C4)</item> returns 17 if the contents of C4 = <item type="input">17:20:00</item>.</paragraph> -<embed href="text/shared/00/00000001.xhp#siehe"/> -<paragraph role="paragraph" id="par_id3154188" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp" name="YEAR">YEAR</link>, <link href="text/scalc/01/04060102.xhp" name="NOW">NOW</link>, <link href="text/scalc/01/04060102.xhp" name="MINUTE">MINUTE</link>, <link href="text/scalc/01/04060102.xhp" name="MONTH">MONTH</link>, <link href="text/scalc/01/04060102.xhp" name="DAY">DAY</link>, <link href="text/scalc/01/04060102.xhp" name="WEEKDAY">WEEKDAY</link>.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_isoweeknum.xhp b/source/text/scalc/01/func_isoweeknum.xhp index 9556aecd4b..96f58c8666 100644 --- a/source/text/scalc/01/func_isoweeknum.xhp +++ b/source/text/scalc/01/func_isoweeknum.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_isoweeknumxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">ISOWEEKNUM</title> @@ -31,11 +26,12 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>ISOWEEKNUM function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISOWEEKNUM" id="bm_id3158403" localize="false"/><paragraph role="heading" id="hd_id3159161" xml-lang="en-US" level="2"><variable id="isoweeknum"><link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISOWEEKNUM" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="isoweeknum"><link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> +</variable></h2> <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_ISOWEEKNUM">ISOWEEKNUM calculates the week number of the year for the internal date value.</ahelp></paragraph> -<paragraph role="note" id="par_idN105E4" xml-lang="en-US">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.</paragraph> +<note id="par_idN105E4">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.</note> <embed href="text/scalc/00/avail_release.xhp#5.1"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3147236" xml-lang="en-US">ISOWEEKNUM(Number)</paragraph> <paragraph role="paragraph" id="par_id3147511" xml-lang="en-US"> @@ -45,5 +41,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=ISOWEEKNUM(DATE(1995;1;1))</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph> <paragraph role="paragraph" id="par_id3149794" xml-lang="en-US"><item type="input">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_minute.xhp b/source/text/scalc/01/func_minute.xhp index 91c4cb1c09..1bea6607f4 100644 --- a/source/text/scalc/01/func_minute.xhp +++ b/source/text/scalc/01/func_minute.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_minutexml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">MINUTE</title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149803"><bookmark_value>MINUTE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/><paragraph role="heading" id="hd_id3149803" xml-lang="en-US" level="2"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/><h2 id="hd_id3149803"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link> +</variable></h2> <paragraph role="paragraph" id="par_id3148988" xml-lang="en-US"><ahelp hid="HID_FUNC_MINUTE">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3148660" xml-lang="en-US">MINUTE(Number)</paragraph> <paragraph role="paragraph" id="par_id3154611" xml-lang="en-US"> @@ -45,5 +41,8 @@ <item type="input">=MINUTE(8.9999)</item> returns 59</paragraph> <paragraph role="paragraph" id="par_id3144755" xml-lang="en-US"> <item type="input">=MINUTE(NOW())</item> returns the current minute value.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_month.xhp b/source/text/scalc/01/func_month.xhp index 038db6f654..9ae8ce5f5e 100644 --- a/source/text/scalc/01/func_month.xhp +++ b/source/text/scalc/01/func_month.xhp @@ -26,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149936"><bookmark_value>MONTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/><paragraph role="heading" id="hd_id3149936" xml-lang="en-US" level="2"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MONAT" id="bm_id3150628" localize="false"/><h2 id="hd_id3149936"><variable id="month"><link href="text/scalc/01/func_month.xhp">MONTH</link> +</variable></h2> <paragraph role="paragraph" id="par_id3153538" xml-lang="en-US"><ahelp hid="HID_FUNC_MONAT">Returns the month for the given date value.</ahelp> The month is returned as an integer between 1 and 12.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3145602" xml-lang="en-US">MONTH(Number)</paragraph> <paragraph role="paragraph" id="par_id3149485" xml-lang="en-US"> @@ -38,5 +39,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3149244" xml-lang="en-US"><item type="input">=MONTH(NOW())</item> returns the current month.</paragraph> <paragraph role="paragraph" id="par_id3154790" xml-lang="en-US"><item type="input">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4 (that date value might get formatted differently after you press Enter).</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index 5df0a4556a..6433879244 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -51,10 +51,7 @@ <paragraph id="par_id231020162249556946" role="paragraph" xml-lang="en-US">The function can be used without the two optional parameters – weekday and holidays – by leaving them out:</paragraph> <paragraph id="par_id23102016224955931" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days.</paragraph> <section id="relatedtopics"> - <embed href="text/scalc/01/func_networkdays.xhp#networkdays"/> - <embed href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> - <embed href="text/scalc/01/func_workday.xhp#workday"/> -<paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_networkdays.xhp b/source/text/scalc/01/func_networkdays.xhp index f22da61b03..19527b6f53 100644 --- a/source/text/scalc/01/func_networkdays.xhp +++ b/source/text/scalc/01/func_networkdays.xhp @@ -37,6 +37,7 @@ <h2 id="hd_id3151254"><variable id="networkdays"><link href="text/scalc/01/func_networkdays.xhp">NETWORKDAYS</link></variable></h2> <paragraph id="par_id3153788" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_NETWORKDAYS">Returns the number of workdays between a <emph>start date</emph> and an <emph>end date</emph>. Holidays can be deducted.</ahelp></paragraph> <embed href="text/scalc/01/04060102.xhp#ADD_note"/> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3145775" role="code" xml-lang="en-US">NETWORKDAYS(StartDate; EndDate; Holidays; Workdays)</paragraph> <paragraph id="par_id3153885" role="paragraph" xml-lang="en-US"><emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.</paragraph> @@ -51,11 +52,7 @@ <paragraph id="par_id160920161751233621" role="paragraph" xml-lang="en-US">How many workdays fall between September 12nd and 25th in 2016 if only Mondays, Tuesdays and Wednesdays are considered as workdays?</paragraph> <paragraph id="par_id160920161751235483" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays.</paragraph> <section id="relatedtopics"> - <embed href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/> - <embed href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> - <embed href="text/scalc/01/func_workday.xhp#workday"/> -<paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> </section> </body> - </helpdocument> diff --git a/source/text/scalc/01/func_now.xhp b/source/text/scalc/01/func_now.xhp index 1d241fb8cb..fbb84d2ed1 100644 --- a/source/text/scalc/01/func_now.xhp +++ b/source/text/scalc/01/func_now.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_nowxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">NOW</title> @@ -31,14 +26,18 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150521"><bookmark_value>NOW function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JETZT" id="bm_id3150532" localize="false"/><paragraph role="heading" id="hd_id3150521" xml-lang="en-US" level="2"><variable id="now"><link href="text/scalc/01/func_now.xhp">NOW</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JETZT" id="bm_id3150532" localize="false"/><h2 id="hd_id3150521"><variable id="now"><link href="text/scalc/01/func_now.xhp">NOW</link> +</variable></h2> <paragraph role="paragraph" id="par_id3148829" xml-lang="en-US"><ahelp hid="HID_FUNC_JETZT">Returns the computer system date and time.</ahelp> The value is updated when you recalculate the document or each time a cell value is modified.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3154897" xml-lang="en-US">NOW()</paragraph> <paragraph role="paragraph" id="par_id4598529" xml-lang="en-US">NOW is a function without arguments.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3150774" xml-lang="en-US"> <item type="input">=NOW()-A1</item> returns the difference between the date in A1 and now. Format the result as a number.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_second.xhp b/source/text/scalc/01/func_second.xhp index a51a4801b4..0baee1eed5 100644 --- a/source/text/scalc/01/func_second.xhp +++ b/source/text/scalc/01/func_second.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_secondxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">SECOND </title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159390"><bookmark_value>SECOND function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/><paragraph role="heading" id="hd_id3159390" xml-lang="en-US" level="2"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SEKUNDE" id="bm_id3155499" localize="false"/><h2 id="hd_id3159390"><variable id="second"><link href="text/scalc/01/func_second.xhp">SECOND</link> +</variable></h2> <paragraph role="paragraph" id="par_id3148974" xml-lang="en-US"><ahelp hid="HID_FUNC_SEKUNDE">Returns the second for the given time value.</ahelp> The second is given as an integer between 0 and 59.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3148407" xml-lang="en-US">SECOND(Number)</paragraph> <paragraph role="paragraph" id="par_id3155904" xml-lang="en-US"> @@ -43,5 +39,8 @@ <item type="input">=SECOND(NOW())</item> returns the current second</paragraph> <paragraph role="paragraph" id="par_id3150831" xml-lang="en-US"> <item type="input">=SECOND(C4)</item> returns 17 if contents of C4 = <item type="input">12:20:17</item>.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_time.xhp b/source/text/scalc/01/func_time.xhp index de55b8a666..1aac1737ce 100644 --- a/source/text/scalc/01/func_time.xhp +++ b/source/text/scalc/01/func_time.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_timexml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">TIME </title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154073"><bookmark_value>TIME function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEIT" id="bm_id3150289" localize="false"/><paragraph role="heading" id="hd_id3154073" xml-lang="en-US" level="2"><variable id="time"><link href="text/scalc/01/func_time.xhp">TIME</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEIT" id="bm_id3150289" localize="false"/><h2 id="hd_id3154073"><variable id="time"><link href="text/scalc/01/func_time.xhp">TIME</link> +</variable></h2> <paragraph role="paragraph" id="par_id3145762" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEIT">TIME returns the current time value from values for hours, minutes and seconds.</ahelp> This function can be used to convert a time based on these three elements to a decimal time value.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3154584" xml-lang="en-US">TIME(Hour; Minute; Second)</paragraph> <paragraph role="paragraph" id="par_id3152904" xml-lang="en-US">Use an integer to set the <emph>Hour</emph>.</paragraph> @@ -44,5 +40,8 @@ <item type="input">=TIME(0;0;0)</item> returns 00:00:00</paragraph> <paragraph role="paragraph" id="par_id3156090" xml-lang="en-US"> <item type="input">=TIME(4;20;4)</item> returns 04:20:04</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_timevalue.xhp b/source/text/scalc/01/func_timevalue.xhp index eb03aada5c..7e6f442d5e 100644 --- a/source/text/scalc/01/func_timevalue.xhp +++ b/source/text/scalc/01/func_timevalue.xhp @@ -28,8 +28,9 @@ <bookmark_value>TIMEVALUE function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEITWERT" id="bm_id3146767" localize="false"/> -<paragraph id="hd_id3146755" role="heading" xml-lang="en-US" level="2"><variable id="timevalue"><link href="text/scalc/01/func_timevalue.xhp">TIMEVALUE</link></variable></paragraph> -<paragraph id="par_id3148502" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEITWERT">TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.</ahelp></paragraph><embed href="text/scalc/01/ODFF.xhp#odff"/> +<h2 id="hd_id3146755"><variable id="timevalue"><link href="text/scalc/01/func_timevalue.xhp">TIMEVALUE</link></variable></h2> +<paragraph id="par_id3148502" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZEITWERT">TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <paragraph id="par_id3150794" role="paragraph" xml-lang="en-US">The internal number indicated as a decimal is the result of the date system used under $[officename] to calculate date entries.</paragraph> <paragraph id="par_id011920090347118" role="paragraph" xml-lang="en-US">If the text string also includes a year, month, or day, TIMEVALUE only returns the fractional part of the conversion.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> @@ -38,5 +39,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3146829" role="paragraph" xml-lang="en-US"><item type="input">=TIMEVALUE("4PM")</item> returns 0.67. When formatting in time format HH:MM:SS, you then get 16:00:00.</paragraph> <paragraph id="par_id3153632" role="paragraph" xml-lang="en-US"><item type="input">=TIMEVALUE("24:00")</item> returns 0. If you use the HH:MM:SS time format, the value is 00:00:00.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_today.xhp b/source/text/scalc/01/func_today.xhp index 35b6bfdd27..ac5fee6e82 100644 --- a/source/text/scalc/01/func_today.xhp +++ b/source/text/scalc/01/func_today.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_todayxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">TODAY</title> @@ -31,14 +26,18 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3145659"><bookmark_value>TODAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HEUTE" id="bm_id3147267" localize="false"/><paragraph role="heading" id="hd_id3145659" xml-lang="en-US" level="2"><variable id="today"><link href="text/scalc/01/func_today.xhp">TODAY</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HEUTE" id="bm_id3147267" localize="false"/><h2 id="hd_id3145659"><variable id="today"><link href="text/scalc/01/func_today.xhp">TODAY</link> +</variable></h2> <paragraph role="paragraph" id="par_id3153759" xml-lang="en-US"><ahelp hid="HID_FUNC_HEUTE">Returns the current computer system date.</ahelp> The value is updated when you reopen the document or modify the values of the document.</paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3153154" xml-lang="en-US">TODAY()</paragraph> <paragraph role="paragraph" id="par_id3154741" xml-lang="en-US"> TODAY is a function without arguments.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3156106" xml-lang="en-US"> <item type="input">TODAY()</item> returns the current computer system date.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_weekday.xhp b/source/text/scalc/01/func_weekday.xhp index 2f23bdb6d0..2cc26363f5 100644 --- a/source/text/scalc/01/func_weekday.xhp +++ b/source/text/scalc/01/func_weekday.xhp @@ -33,9 +33,9 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WOCHENTAG" id="bm_id3152359" localize="false"/> -<paragraph id="hd_id3154925" role="heading" level="2" xml-lang="en-US"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> </variable></paragraph> +<h2 id="hd_id3154925"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> </variable></h2> <paragraph id="par_id3154228" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WOCHENTAG">Returns the day of the week for the given date value.</ahelp> The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. For other types, see the table below.</paragraph> - +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3149033" role="code" xml-lang="en-US">WEEKDAY(Number; Type)</paragraph> <paragraph id="par_id3149046" role="paragraph" xml-lang="en-US"> <emph>Number</emph>, as a date value, is a decimal for which the weekday is to be returned.</paragraph> @@ -132,8 +132,8 @@ </tablerow> </table> -<paragraph id="par_id3156188" role="note" xml-lang="en-US">These values apply only to the standard date format that you select under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item> -</caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem">- %PRODUCTNAME Calc - Calculate</item>.</paragraph> +<note id="par_id3156188">These values apply only to the standard date format that you select under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item> +</caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem">- %PRODUCTNAME Calc - Calculate</item>.</note> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> @@ -142,7 +142,10 @@ <paragraph id="par_id3153525" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("1996-07-24";1)</item> returns 4 (the Type parameter is 1, therefore Sunday is day number 1. July 24, 1996 was a Wednesday and therefore day number 4).</paragraph> <paragraph id="par_id050220170616006699" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY("2017-05-02";14)</item> returns 6 (the Type parameter is 14, therefore Thursday is day number 1. May 2, 2017 was a Tuesday and therefore day number 6)</paragraph> <paragraph id="par_id3150575" role="paragraph" xml-lang="en-US"><item type="input">=WEEKDAY(NOW())</item> returns the number of the current day.</paragraph> -<paragraph id="par_id3150588" role="tip" xml-lang="en-US">To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: <br/><item type="input">IF(WEEKDAY(A1;2)<6;"Business day";"Weekend")</item></paragraph> +<tip id="par_id3150588">To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: <br/><item type="input">IF(WEEKDAY(A1;2)<6;"Business day";"Weekend")</item></tip> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp index 31695d9953..a23d5cdf50 100644 --- a/source/text/scalc/01/func_weeknum.xhp +++ b/source/text/scalc/01/func_weeknum.xhp @@ -26,8 +26,8 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/><paragraph role="heading" id="hd_id3159161" xml-lang="en-US" level="2"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> +</variable></h2> <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_KALENDERWOCHE">WEEKNUM calculates the week number of the year for the internal date value as defined in ODF OpenFormula and compatible with other spreadsheet applications.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3147220" xml-lang="en-US">Supported are two week numbering systems:</paragraph> <table id="tab_id481535122363435"> @@ -49,13 +49,14 @@ </tablerow> <tablerow> <tablecell> - <paragraph id="par_id741535122455285" role="tablecontent" xml-lang="en-US" >System 2</paragraph> + <paragraph id="par_id741535122455285" role="tablecontent" xml-lang="en-US">System 2</paragraph> </tablecell> <tablecell> <paragraph role="tablecontent" id="par_id3147222" xml-lang="en-US">The week containing the first Thursday of the year is the first week of the year, and is numbered week 1. That means that week number 1 of any year is the week that contains January 4th. ISO 8601 defines this system and that the week starts on Monday.</paragraph> </tablecell> </tablerow> </table> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3147236" xml-lang="en-US">WEEKNUM(Number [; Mode])</paragraph> <paragraph role="paragraph" id="par_id3147511" xml-lang="en-US"> @@ -65,7 +66,7 @@ <table id="tab_id491535122633826"> <tablerow> <tablecell> - <paragraph id="par_id961535122993923" role="tablehead" xml-lang="en-US" >System</paragraph> + <paragraph id="par_id961535122993923" role="tablehead" xml-lang="en-US">System</paragraph> </tablecell> <tablecell> <paragraph id="par_id151535122633826" role="tablehead" xml-lang="en-US">Mode</paragraph> @@ -76,7 +77,7 @@ </tablerow> <tablerow> <tablecell rowspan="9"> - <paragraph id="par_id531535124180000" role="tablecontents" xml-lang="en-US" >System 1</paragraph> + <paragraph id="par_id531535124180000" role="tablecontents" xml-lang="en-US">System 1</paragraph> </tablecell> <tablecell> <paragraph id="par_id931535122633827" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph> @@ -90,7 +91,7 @@ <paragraph id="par_id441535122735565" role="tablecontents" xml-lang="en-US" localize="false">2</paragraph> </tablecell> <tablecell> - <paragraph id="par_id591535122756686" role="tablecontents" xml-lang="en-US" >Monday</paragraph> + <paragraph id="par_id591535122756686" role="tablecontents" xml-lang="en-US">Monday</paragraph> </tablecell> </tablerow> <tablerow> @@ -98,7 +99,7 @@ <paragraph id="par_id541535122798459" role="tablecontents" xml-lang="en-US" localize="false">11</paragraph> </tablecell> <tablecell> - <paragraph id="par_id881535122835126" role="tablecontents" xml-lang="en-US" >Monday</paragraph> + <paragraph id="par_id881535122835126" role="tablecontents" xml-lang="en-US">Monday</paragraph> </tablecell> </tablerow> <tablerow> @@ -106,7 +107,7 @@ <paragraph id="par_id941535122866815" role="tablecontent" xml-lang="en-US" localize="false">12</paragraph> </tablecell> <tablecell> - <paragraph id="par_id241535122903569" role="tablecontents" xml-lang="en-US" >Tuesday</paragraph> + <paragraph id="par_id241535122903569" role="tablecontents" xml-lang="en-US">Tuesday</paragraph> </tablecell> </tablerow> <tablerow> @@ -114,7 +115,7 @@ <paragraph id="par_id271535124253476" role="tablecontents" xml-lang="en-US" localize="false">13</paragraph> </tablecell> <tablecell> - <paragraph id="par_id31535124277973" role="tablecontents" xml-lang="en-US" >Wednesday</paragraph> + <paragraph id="par_id31535124277973" role="tablecontents" xml-lang="en-US">Wednesday</paragraph> </tablecell> </tablerow> <tablerow> @@ -122,7 +123,7 @@ <paragraph id="par_id281535124290548" role="tablecontents" xml-lang="en-US" localize="false">14</paragraph> </tablecell> <tablecell> - <paragraph id="par_id21535124310462" role="tablecontents" xml-lang="en-US" >Thursday</paragraph> + <paragraph id="par_id21535124310462" role="tablecontents" xml-lang="en-US">Thursday</paragraph> </tablecell> </tablerow> <tablerow> @@ -130,7 +131,7 @@ <paragraph id="par_id721535124338290" role="tablecontents" xml-lang="en-US" localize="false">15</paragraph> </tablecell> <tablecell> - <paragraph id="par_id921535124365435" role="tablecontents" xml-lang="en-US" >Friday</paragraph> + <paragraph id="par_id921535124365435" role="tablecontents" xml-lang="en-US">Friday</paragraph> </tablecell> </tablerow> <tablerow> @@ -138,26 +139,26 @@ <paragraph id="par_id781535124380237" role="tablecontents" xml-lang="en-US" localize="false">16</paragraph> </tablecell> <tablecell> - <paragraph id="par_id211535124416253" role="tablecontents" xml-lang="en-US" >Saturday</paragraph> + <paragraph id="par_id211535124416253" role="tablecontents" xml-lang="en-US">Saturday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id601535124440320" role="tablecontents" xml-lang="en-US" localize="false" >17</paragraph> + <paragraph id="par_id601535124440320" role="tablecontents" xml-lang="en-US" localize="false">17</paragraph> </tablecell> <tablecell> - <paragraph id="par_id461535124473824" role="tablecontents" xml-lang="en-US" >Sunday</paragraph> + <paragraph id="par_id461535124473824" role="tablecontents" xml-lang="en-US">Sunday</paragraph> </tablecell> </tablerow> <tablerow> <tablecell rowspan="2"> - <paragraph id="par_id471535124489997" role="tablecontents" xml-lang="en-US" >System 2</paragraph> + <paragraph id="par_id471535124489997" role="tablecontents" xml-lang="en-US">System 2</paragraph> </tablecell> <tablecell> <paragraph id="par_id431535124539573" role="tablecontents" xml-lang="en-US" localize="false">21</paragraph> </tablecell> <tablecell> - <paragraph id="par_id391535124564520" role="tablecontents" xml-lang="en-US" >Monday (ISO 8601)</paragraph> + <paragraph id="par_id391535124564520" role="tablecontents" xml-lang="en-US">Monday (ISO 8601)</paragraph> </tablecell> </tablerow> <tablerow> @@ -165,7 +166,7 @@ <paragraph id="par_id971535124578111" role="tablecontents" xml-lang="en-US" localize="false">150</paragraph> </tablecell> <tablecell> - <paragraph id="par_id661535124640643" role="tablecontents" xml-lang="en-US" >(ISO 8601, for interoperability with Gnumeric)</paragraph> + <paragraph id="par_id661535124640643" role="tablecontents" xml-lang="en-US">(ISO 8601, for interoperability with Gnumeric)</paragraph> </tablecell> </tablerow> </table> @@ -176,5 +177,8 @@ <paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);2)</item> returns 52. If the week starts on Monday, Sunday belongs to the last week of the previous year.</paragraph> <paragraph role="paragraph" id="par_id3149793" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1995;1;1);21)</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph> <paragraph role="paragraph" id="par_id3149794" xml-lang="en-US"><item type="input">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on Monday, 1999-01-04.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_weeknum_ooo.xhp b/source/text/scalc/01/func_weeknum_ooo.xhp index 8304d3a971..a4de840922 100644 --- a/source/text/scalc/01/func_weeknum_ooo.xhp +++ b/source/text/scalc/01/func_weeknum_ooo.xhp @@ -26,10 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3159161"><bookmark_value>WEEKNUM_OOO function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEEKNUM_OOO" id="bm_id3158403" localize="false"/><paragraph role="heading" id="hd_id3159161" xml-lang="en-US" level="2"><variable id="weeknum_ooo"><link href="text/scalc/01/func_weeknum_ooo.xhp">WEEKNUM_OOO</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEEKNUM_OOO" id="bm_id3158403" localize="false"/><h2 id="hd_id3159161"><variable id="weeknum_ooo"><link href="text/scalc/01/func_weeknum_ooo.xhp">WEEKNUM_OOO</link> +</variable></h2> <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp hid="HID_FUNC_WEEKNUM_OOO">WEEKNUM_OOO calculates the week number of the year for the internal date value.</ahelp></paragraph> -<paragraph role="note" id="par_idN105E4" xml-lang="en-US">This function exists for interoperability with %PRODUCTNAME releases older than 5.1.0 and OpenOffice.org. It calculates week numbers for a week numbering system in that week number 1 is the week that contains the January 4th. This function does not provide interoperability with other spreadsheet applications. For new documents use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function instead.</paragraph> +<note id="par_idN105E4">This function exists for interoperability with %PRODUCTNAME releases older than 5.1.0 and OpenOffice.org. It calculates week numbers for a week numbering system in that week number 1 is the week that contains the January 4th. This function does not provide interoperability with other spreadsheet applications. For new documents use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function instead.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3147236" xml-lang="en-US">WEEKNUM_OOO(Number; Mode)</paragraph> <paragraph role="paragraph" id="par_id3147511" xml-lang="en-US"> @@ -44,5 +44,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3150704" xml-lang="en-US"><item type="input">=WEEKNUM_OOO(DATE(1995;1;1);1)</item> returns 1</paragraph> <paragraph role="paragraph" id="par_id3149792" xml-lang="en-US"><item type="input">=WEEKNUM_OOO(DATE(1995;1;1);2)</item> returns 52. Week 1 starts on Monday, 1995-01-02.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_weeknumadd.xhp b/source/text/scalc/01/func_weeknumadd.xhp index 53f2347739..57f838d9a1 100644 --- a/source/text/scalc/01/func_weeknumadd.xhp +++ b/source/text/scalc/01/func_weeknumadd.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_weeknumaddxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">WEEKNUM_EXCEL2003 </title> @@ -31,10 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3166443"><bookmark_value>WEEKNUM_EXCEL2003 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><paragraph role="heading" id="hd_id3166443" xml-lang="en-US" level="2"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WEEKNUM" id="bm_id3166454" localize="false"/><h2 id="hd_id3166443"><variable id="weeknumadd"><link href="text/scalc/01/func_weeknumadd.xhp">WEEKNUM_EXCEL2003</link> +</variable></h2> <paragraph role="paragraph" id="par_id3152945" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_WEEKNUM">The result indicates the number of the calendar week for a date.</ahelp></paragraph> -<paragraph role="tip" id="par_idN105DD" xml-lang="en-US">The WEEKNUM_EXCEL2003 function is designed to calculate week numbers exactly as Microsoft Excel 2003 did. Use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> function for ODF OpenFormula and Excel 2010 compatibility, or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function when you just need ISO 8601 week numbers. In releases prior to $[officename] 5.1 WEEKNUM_EXCEL2003 was named WEEKNUM_ADD.</paragraph> +<tip id="par_idN105DD">The WEEKNUM_EXCEL2003 function is designed to calculate week numbers exactly as Microsoft Excel 2003 did. Use the <link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link> function for ODF OpenFormula and Excel 2010 compatibility, or <link href="text/scalc/01/func_isoweeknum.xhp">ISOWEEKNUM</link> function when you just need ISO 8601 week numbers. In releases prior to $[officename] 5.1 WEEKNUM_EXCEL2003 was named WEEKNUM_ADD.</tip> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3153685" xml-lang="en-US">WEEKNUM_EXCEL2003(Date; ReturnType)</paragraph> <paragraph role="paragraph" id="par_id3159277" xml-lang="en-US"> @@ -45,5 +40,8 @@ <paragraph role="paragraph" id="par_id3149973" xml-lang="en-US">In which week number does 2001-12-24 fall?</paragraph> <paragraph role="paragraph" id="par_id3149914" xml-lang="en-US"> <item type="input">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> returns 52.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_workday.intl.xhp b/source/text/scalc/01/func_workday.intl.xhp index 4f4a31ae91..c986c5be3c 100644 --- a/source/text/scalc/01/func_workday.intl.xhp +++ b/source/text/scalc/01/func_workday.intl.xhp @@ -57,10 +57,7 @@ <paragraph id="par_id241020160012181870" role="paragraph" xml-lang="en-US">The function can be used without the two optional parameters – Weekday and Holidays – by leaving them out:</paragraph> <paragraph id="par_id241020160012182048" role="paragraph" xml-lang="en-US"><item type="input">=WORKDAY.INTL(C3;D3)</item> gives the result: January 10, 2017.</paragraph> <section id="relatedtopics"> - <embed href="text/scalc/01/func_networkdays.xhp#networkdays"/> - <embed href="text/scalc/01/func_networkdays.intl.xhp#networkdaysintl"/> - <embed href="text/scalc/01/func_workday.xhp#workday"/> -<paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_workday.xhp b/source/text/scalc/01/func_workday.xhp index 21120d6e0d..bd6f5c0030 100644 --- a/source/text/scalc/01/func_workday.xhp +++ b/source/text/scalc/01/func_workday.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_workdayxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">WORKDAY</title> @@ -34,6 +29,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_WORKDAY" id="bm_id3150028" localize="false"/> <h2 id="hd_id3149012"><variable id="workday"><link href="text/scalc/01/func_workday.xhp">WORKDAY</link></variable></h2> <paragraph role="paragraph" id="par_id3149893" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_WORKDAY"> The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of <emph>workdays</emph> away from the <emph>start date</emph>.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3154844" xml-lang="en-US">WORKDAY(StartDate; Days; Holidays)</paragraph> <paragraph role="paragraph" id="par_id3147469" xml-lang="en-US"> @@ -53,5 +49,8 @@ <embed href="text/scalc/01/func_workday.intl.xhp#workdaysintl"/> <paragraph id="par_id23102016225717242" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060102.xhp">Date functions</link></paragraph> </section> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_year.xhp b/source/text/scalc/01/func_year.xhp index 0adf3b23c8..c2fe1b6357 100644 --- a/source/text/scalc/01/func_year.xhp +++ b/source/text/scalc/01/func_year.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_yearxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">YEAR</title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3153982"><bookmark_value>YEAR function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/><paragraph role="heading" id="hd_id3153982" xml-lang="en-US" level="2"><variable id="year"><link href="text/scalc/01/func_year.xhp">YEAR</link> -</variable></paragraph> -<paragraph role="paragraph" id="par_id3147496" xml-lang="en-US"><ahelp hid="HID_FUNC_JAHR">Returns the year as a number according to the internal calculation rules.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JAHR" id="bm_id3159179" localize="false"/><h2 id="hd_id3153982"><variable id="year"><link href="text/scalc/01/func_year.xhp">YEAR</link> +</variable></h2> +<paragraph role="paragraph" id="par_id3147496" xml-lang="en-US"><ahelp hid="HID_FUNC_JAHR">Returns the year as a number according to the <link href="text/scalc/01/04060102.xhp#datebase" name="date calculation rules">internal calculation rules</link>.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3154304" xml-lang="en-US">YEAR(Number)</paragraph> <paragraph role="paragraph" id="par_id3156013" xml-lang="en-US"> @@ -45,5 +41,10 @@ <item type="input">=YEAR(2)</item> returns 1900</paragraph> <paragraph role="paragraph" id="par_id3150115" xml-lang="en-US"> <item type="input">=YEAR(33333.33)</item> returns 1991</paragraph> +<paragraph role="paragraph" id="par_id141577548861101"><input>=YEAR(DATEVALUE('2010-09-28'))</input> returns 2010.</paragraph> + +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_yearfrac.xhp b/source/text/scalc/01/func_yearfrac.xhp index 20d5747c80..059a0e2028 100644 --- a/source/text/scalc/01/func_yearfrac.xhp +++ b/source/text/scalc/01/func_yearfrac.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,9 +16,7 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalc01func_yearfracxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">YEARFRAC</title> @@ -31,9 +26,10 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3148735"><bookmark_value>YEARFRAC function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YEARFRAC" id="bm_id3149251" localize="false"/><paragraph role="heading" id="hd_id3148735" xml-lang="en-US" level="2"><variable id="yearfrac"><link href="text/scalc/01/func_yearfrac.xhp">YEARFRAC</link> -</variable></paragraph> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YEARFRAC" id="bm_id3149251" localize="false"/> +<h2 id="hd_id3148735"><variable id="yearfrac"><link href="text/scalc/01/func_yearfrac.xhp">YEARFRAC</link></variable></h2> <paragraph role="paragraph" id="par_id3150899" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_YEARFRAC">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3155823" xml-lang="en-US">YEARFRAC(StartDate; EndDate; Basis)</paragraph> <paragraph role="paragraph" id="par_id3145144" xml-lang="en-US"> @@ -46,47 +42,47 @@ <tablecell> <paragraph role="tablehead" id="par_id3146847" xml-lang="en-US">Basis</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3155956" xml-lang="en-US">Calculation</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154502" xml-lang="en-US" localize="false">0 or missing</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149877" xml-lang="en-US">US method (NASD), 12 months of 30 days each</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3148766" xml-lang="en-US" localize="false">1</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154326" xml-lang="en-US">Exact number of days in months, exact number of days in year</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3145245" xml-lang="en-US" localize="false">2</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3155620" xml-lang="en-US">Exact number of days in month, year has 360 days</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3145297" xml-lang="en-US" localize="false">3</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3148394" xml-lang="en-US">Exact number of days in month, year has 365 days</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3151022" xml-lang="en-US" localize="false">4</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150931" xml-lang="en-US">European method, 12 months of 30 days each</paragraph> </tablecell> </tablerow> @@ -97,5 +93,8 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3149007" xml-lang="en-US">What fraction of the year 2008 lies between 2008-01-01 and 2008-07-01?</paragraph> <paragraph role="paragraph" id="par_id3154632" xml-lang="en-US"><item type="input">=YEARFRAC("2008-01-01"; "2008-07-01";0)</item> returns 0.50.</paragraph> +<section id="relatedtopics"> + <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> +</section> </body> </helpdocument> |