diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/func_yearfrac.xhp')
-rw-r--r-- | helpcontent2/source/text/scalc/01/func_yearfrac.xhp | 139 |
1 files changed, 139 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/func_yearfrac.xhp b/helpcontent2/source/text/scalc/01/func_yearfrac.xhp new file mode 100644 index 0000000000..424824efef --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_yearfrac.xhp @@ -0,0 +1,139 @@ +<?xml version="1.0" encoding="UTF-8"?>
+<!--*********************************************************************** + * + * The Contents of this file are made available subject to the terms of + * either of the following licenses + * + * - GNU Lesser General Public License Version 2.1 + * - Sun Industry Standards Source License Version 1.1 + * + * Sun Microsystems Inc., October, 2000 + * + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2000 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + * + * Sun Industry Standards Source License Version 1.1 + * ================================================= + * The contents of this file are subject to the Sun Industry Standards + * Source License Version 1.1 (the "License"); You may not use this file + * except in compliance with the License. You may obtain a copy of the + * License at http://www.openoffice.org/license.html. + * + * Software provided under this License is provided on an "AS IS" basis, + * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, + * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS, + * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. + * See the License for the specific provisions governing your rights and + * obligations concerning the Software. + * + * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. + * + * Copyright: 2000 by Sun Microsystems, Inc. + * + * All Rights Reserved. + * + * Contributor(s): _______________________________________ + * + * + ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc01func_yearfracxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">YEARFRAC</title>
+<filename>text/scalc/01/func_yearfrac.xhp</filename>
+</topic>
+<history>
+<created date="2004-05-19T17:17:34">extracted from 04060102</created>
+<lastedited date="2004-06-16T09:52:19"/>
+</history>
+</meta>
+<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148735"><bookmark_value>YEARFRAC</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_YEARFRAC" id="bm_id3149251" localize="false"/>
+<paragraph role="heading" id="hd_id3148735" xml-lang="en-US" level="2" l10n="U" oldref="196"><variable id="yearfrac"><link href="text/scalc/01/func_yearfrac.xhp">YEARFRAC</link> +</variable></paragraph>
+<embed href="text/shared/00/00000001.xhp#add"/>
+<paragraph role="paragraph" id="par_id3150899" xml-lang="en-US" l10n="U" oldref="197"><ahelp hid="HID_AAI_FUNC_YEARFRAC"> The result is a number between 0 and 1, representing the fraction of a year between <emph>Start date</emph> and <emph>End date</emph>.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3155259" xml-lang="en-US" level="3" l10n="U" oldref="198">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3155823" xml-lang="en-US" l10n="U" oldref="199">YEARFRAC (Start date;End date;Basis)</paragraph>
+<paragraph role="paragraph" id="par_id3145144" xml-lang="en-US" l10n="U" oldref="200">
+<emph>Start date</emph> and <emph>end date</emph>: two date values.</paragraph>
+<section id="basis">
+<paragraph role="paragraph" id="par_id3149954" xml-lang="en-US" l10n="U" oldref="201">
+<emph>Basis</emph>: is chosen from a list of options and indicates how the year is to be calculated.</paragraph>
+<table id="tbl_id3145590">
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablehead" id="par_id3146847" xml-lang="en-US" l10n="U" oldref="202">Basis</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablehead" id="par_id3155956" xml-lang="en-US" l10n="U" oldref="203">Calculation</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3154502" xml-lang="en-US" l10n="U" oldref="204">0 or missing</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3149877" xml-lang="en-US" l10n="U" oldref="205">US method (NASD), 12 months of 30 days each</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3148766" xml-lang="en-US" l10n="U" oldref="250">1</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3154326" xml-lang="en-US" l10n="U" oldref="206">Exact number of days in months, exact number of days in year</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3145245" xml-lang="en-US" l10n="U" oldref="251">2</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3155620" xml-lang="en-US" l10n="U" oldref="207">Exact number of days in month, year has 360 days</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3145297" xml-lang="en-US" l10n="U" oldref="252">3</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3148394" xml-lang="en-US" l10n="U" oldref="208">Exact number of days in month, year has 365 days</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3151022" xml-lang="en-US" l10n="U" oldref="253">4</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="tablecontent" id="par_id3150931" xml-lang="en-US" l10n="U" oldref="209">European method, 12 months of 30 days each</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+</section>
+<paragraph role="heading" id="hd_id3145626" xml-lang="en-US" level="3" l10n="U" oldref="210">Example</paragraph>
+<paragraph role="paragraph" id="par_id3149007" xml-lang="en-US" l10n="U" oldref="211">What fraction of the year 2001 lies between 1.1.2002 and 7.1.2001?</paragraph>
+<paragraph role="code" id="par_id3154632" xml-lang="en-US" l10n="U" oldref="212">=YEARFRAC("1.1.2002"; "7.1.2002";1) returns 0.495890.</paragraph>
+</body>
+</helpdocument>
|