diff options
Diffstat (limited to 'source/text/scalc/01/04060111.xhp')
| -rw-r--r-- | source/text/scalc/01/04060111.xhp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060111.xhp b/source/text/scalc/01/04060111.xhp index b7f6105014..e9ed72c69b 100644 --- a/source/text/scalc/01/04060111.xhp +++ b/source/text/scalc/01/04060111.xhp @@ -175,10 +175,10 @@ <note id="par_id971641990480242">This function considers Monday to be the first day of the week regardless of the current locale settings.</note> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id671641994821992">In the following examples, dates are passed as strings. However, they can also be stored in separate cells and be passed as references.</paragraph> -<paragraph role="paragraph" id="par_id71641991391639"><input>=WEEKS("01/12/2022","01/17/2022",0)</input> returns 0 because <emph>Type</emph> was set to 0 and there are only 5 days in the interval.</paragraph> -<paragraph role="paragraph" id="par_id71641991390039"><input>=WEEKS("01/12/2022","01/19/2022",0)</input> returns 1 because <emph>Type</emph> was set to 0 and there are 7 days in the interval.</paragraph> -<paragraph role="paragraph" id="par_id71641991391123"><input>=WEEKS("01/12/2022","01/17/2022",1)</input> returns 1 because <emph>Type</emph> was set to 1 and the interval contains a Monday, since 01/12/2022 is a Wednesday and 01/17/2022 is a Monday.</paragraph> -<paragraph role="paragraph" id="par_id71641991332523"><input>=WEEKS("01/10/2022","01/15/2022",1)</input> returns 0 because <emph>Type</emph> was set to 1 and the interval does not contain any Mondays, except for the start date.</paragraph> +<paragraph role="paragraph" id="par_id71641991391639"><input>=WEEKS("2022-01-12","2022-01-17",0)</input> returns 0 because <emph>Type</emph> was set to 0 and there are only 5 days in the interval.</paragraph> +<paragraph role="paragraph" id="par_id71641991390039"><input>=WEEKS("2022-01-12","2022-01-19",0)</input> returns 1 because <emph>Type</emph> was set to 0 and there are 7 days in the interval.</paragraph> +<paragraph role="paragraph" id="par_id71641991391123"><input>=WEEKS("2022-01-12","2022-01-17",1)</input> returns 1 because <emph>Type</emph> was set to 1 and the interval contains a Monday, since 2022-01-12 is a Wednesday and 2022-01-17 is a Monday.</paragraph> +<paragraph role="paragraph" id="par_id71641991332523"><input>=WEEKS("2022-01-12","2022-01-15",1)</input> returns 0 because <emph>Type</emph> was set to 1 and the interval does not contain any Mondays, except for the start date.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>ORG.OPENOFFICE.WEEKS</literal></paragraph> |