diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2008-01-24 12:57:52 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2008-01-24 12:57:52 +0000 |
| commit | 74f140095a128c9e87a529b15c86ab23cafdd79b (patch) | |
| tree | 9e2a5eb0eb02bf84fd49d178ebe9c8a80eb100a4 /helpcontent2/source/text/scalc/01/func_weekday.xhp | |
| parent | INTEGRATION: CWS hcshared15 (1.6.6); FILE MERGED (diff) | |
| download | help-74f140095a128c9e87a529b15c86ab23cafdd79b.tar.gz help-74f140095a128c9e87a529b15c86ab23cafdd79b.zip | |
INTEGRATION: CWS hcshared15 (1.4.266); FILE MERGED
2008/01/11 14:00:18 ufi 1.4.266.2: new makefiles und zwischenstand
2007/12/18 12:12:16 ufi 1.4.266.1: saving
Diffstat (limited to 'helpcontent2/source/text/scalc/01/func_weekday.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_weekday.xhp | 43 |
1 files changed, 23 insertions, 20 deletions
diff --git a/helpcontent2/source/text/scalc/01/func_weekday.xhp b/helpcontent2/source/text/scalc/01/func_weekday.xhp index 69f26835e6..9aecd13186 100644 --- a/helpcontent2/source/text/scalc/01/func_weekday.xhp +++ b/helpcontent2/source/text/scalc/01/func_weekday.xhp @@ -1,13 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** + +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: func_weekday.xhp,v $ + * $RCSfile: func_weekday.xhp,v $fileonly,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:07:08 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:57:24 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,38 +34,39 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************ + --> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc01func_weekdayxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">WEEKDAY </title> <filename>/text/scalc/01/func_weekday.xhp</filename> </topic> -<history> -<created date="2004-05-27T16:43:42"/> -<lastedited date="2004-09-27T12:14:40">YJ: checked</lastedited> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154925"><bookmark_value>WEEKDAY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WOCHENTAG" id="bm_id3152359" localize="false"/> -<paragraph role="heading" id="hd_id3154925" xml-lang="en-US" level="2" l10n="U" oldref="136"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WOCHENTAG" id="bm_id3152359" localize="false"/><paragraph role="heading" id="hd_id3154925" xml-lang="en-US" level="2" l10n="U" oldref="136"><variable id="weekday"><link href="text/scalc/01/func_weekday.xhp">WEEKDAY</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3154228" xml-lang="en-US" l10n="U" oldref="137"><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. If type=2, numbering begins at Monday=1; and if type=3 numbering begins at Monday=0.</paragraph> +<paragraph role="paragraph" id="par_id3154228" xml-lang="en-US" l10n="U" oldref="137"><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. If type=2, numbering begins at Monday=1; and if type=3 numbering begins at Monday=0.</paragraph> <paragraph role="heading" id="hd_id3147217" xml-lang="en-US" level="3" l10n="U" oldref="138">Syntax</paragraph> -<paragraph role="paragraph" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="139">WEEKDAY(Number; Type)</paragraph> +<paragraph role="code" id="par_id3149033" xml-lang="en-US" l10n="U" oldref="139">WEEKDAY(Number; Type)</paragraph> <paragraph role="paragraph" id="par_id3149046" xml-lang="en-US" l10n="U" oldref="140"> <emph>Number</emph>, as a date value, is a decimal for which the weekday is to be returned.</paragraph> <paragraph role="paragraph" id="par_id3154394" xml-lang="en-US" l10n="U" oldref="141"> -<emph>Type</emph> determines the type of calculation. For Type =1, the weekdays are counted starting from Sunday (this is the default even when the Type parameter is missing). For Type =2, the weekdays are counted starting from Monday =1. For Type = 3, the weekdays are counted starting from Monday = 0.</paragraph> +<emph>Type</emph> determines the type of calculation. For Type=1, the weekdays are counted starting from Sunday (this is the default even when the Type parameter is missing). For Type=2, the weekdays are counted starting from Monday=1. For Type=3, the weekdays are counted starting from Monday=0.</paragraph> <paragraph role="note" id="par_id3156188" xml-lang="en-US" l10n="U" oldref="142">These values apply only to the standard date format that you select under <emph>Tools - Options - %PRODUCTNAME Calc - Calculate</emph>.</paragraph> <paragraph role="heading" id="hd_id3153836" xml-lang="en-US" level="3" l10n="U" oldref="143">Examples</paragraph> -<paragraph role="paragraph" id="par_id3150317" xml-lang="en-US" l10n="U" oldref="144">WEEKDAY("6/14/2000") returns 4 (the Type parameter is missing, therefore the standard count is used. The standard count starts with Sunday as day number 1. June 14, 2000 was a Wednesday and therefore day number 4).</paragraph> -<paragraph role="paragraph" id="par_id3153174" xml-lang="en-US" l10n="U" oldref="145">WEEKDAY("7/24/1996";2) returns 3 (the Type parameter is 2, therefore Monday is day number 1. July 24, 1996 was a Wednesday and therefore day number 3).</paragraph> -<paragraph role="paragraph" id="par_id3153525" xml-lang="en-US" l10n="U" oldref="146">WEEKDAY("7/24/1996";1) 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 role="paragraph" id="par_id3150575" xml-lang="en-US" l10n="U" oldref="147">WEEKDAY(NOW()) returns the number of the current day.</paragraph> +<paragraph role="paragraph" id="par_id3150317" xml-lang="en-US" l10n="U" oldref="144"> +<item type="input">=WEEKDAY(6/14/2000)</item> returns 4 (the Type parameter is missing, therefore the standard count is used. The standard count starts with Sunday as day number 1. June 14, 2000 was a Wednesday and therefore day number 4).</paragraph> +<paragraph role="paragraph" id="par_id3153174" xml-lang="en-US" l10n="U" oldref="145"> +<item type="input">=WEEKDAY(7/24/1996;2)</item> returns 3 (the Type parameter is 2, therefore Monday is day number 1. July 24, 1996 was a Wednesday and therefore day number 3).</paragraph> +<paragraph role="paragraph" id="par_id3153525" xml-lang="en-US" l10n="U" oldref="146"> +<item type="input">=WEEKDAY(7/24/1996;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 role="paragraph" id="par_id3150575" xml-lang="en-US" l10n="U" oldref="147"> +<item type="input">=WEEKDAY(NOW())</item> returns the number of the current day.</paragraph> <paragraph role="tip" id="par_id3150588" xml-lang="en-US" l10n="U" oldref="171">To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: IF(WEEKDAY(A1;2)<6;"Business day";"Weekend")</paragraph> </body> </helpdocument> |