diff options
| author | Seth Chaiklin <sdc.blanco@youmail.dk> | 2021-03-29 15:24:07 +0200 |
|---|---|---|
| committer | Seth Chaiklin <sdc.blanco@youmail.dk> | 2021-03-29 15:27:15 +0200 |
| commit | a9237a2b7018be667f26f9a93d06b48bccb1015e (patch) | |
| tree | 838694347d30bf76a43327cf9f7fadb39c3173bf | |
| parent | f5e0d8cc4dc5122e3bf4f7c2db4f2503e787aec1 (diff) | |
tdf#137715 NETWORKDAYS.INTL gets "text in data range" note
Change-Id: I95b21703120846babab0dc45c1851294a2c1b5a9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113283
Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
Tested-by: Jenkins
| -rw-r--r-- | source/text/scalc/01/func_networkdays.intl.xhp | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index ed1364ba1f..72c2021728 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -42,6 +42,7 @@ <embed href="text/scalc/01/common_func_workdaysintl.xhp#embed_workdays_intl"/> <embed href="text/scalc/01/04060102.xhp#datenumberinfo"/> <embed href="text/scalc/01/04060102.xhp#datenumberwarn"/> +<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id231020162249554032" role="paragraph" xml-lang="en-US">How many workdays fall between December 15, 2016 and January 14, 2017? Let the start date be located in C3 and the end date in D3. Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017.</paragraph> <paragraph id="par_id231020162249551234" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item> returns 21 workdays with default for weekend days.</paragraph> |