diff options
Diffstat (limited to 'helpcontent2')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_datedif.xhp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/helpcontent2/source/text/scalc/01/func_datedif.xhp b/helpcontent2/source/text/scalc/01/func_datedif.xhp index dcf5549908..5ba17fa3c9 100644 --- a/helpcontent2/source/text/scalc/01/func_datedif.xhp +++ b/helpcontent2/source/text/scalc/01/func_datedif.xhp @@ -93,12 +93,12 @@ <paragraph role="paragraph" id="par_id3152589" xml-lang="en-US"> Birthday calculation. A man was born on 1974-04-17. Today is 2012-06-13.</paragraph> <paragraph role="paragraph" id="par_id3252589" xml-lang="en-US"> -<item type="input">=DATE("1974-04-17";"2012-06-13";"y")</item> yields 38. <item type="input">=DATE("1974-04-17";"2012-06-13";"ym")</item> yields 1. <item type="input">=DATE("1974-04-17";"2012-06-13";"md")</item> yields 27. So he is 38 years, 1 month and 27 days old.</paragraph> +<item type="input">=DATEDIF("1974-04-17";"2012-06-13";"y")</item> yields 38. <item type="input">=DATEDIF("1974-04-17";"2012-06-13";"ym")</item> yields 1. <item type="input">=DATEDIF("1974-04-17";"2012-06-13";"md")</item> yields 27. So he is 38 years, 1 month and 27 days old.</paragraph> <paragraph role="paragraph" id="par_id3352589" xml-lang="en-US"> -<item type="input">=DATE("1974-04-17";"2012-06-13";"m")</item> yields 457, he has been living for 457 months.</paragraph> +<item type="input">=DATEDIF("1974-04-17";"2012-06-13";"m")</item> yields 457, he has been living for 457 months.</paragraph> <paragraph role="paragraph" id="par_id3452589" xml-lang="en-US"> -<item type="input">=DATE("1974-04-17";"2012-06-13";"d")</item> yields 13937, he has been living for 13937 days.</paragraph> +<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">=DATE("1974-04-17";"2012-06-13";"yd")</item> yields 57, his birthday was 57 days ago.</paragraph> +<item type="input">=DATEDIF("1974-04-17";"2012-06-13";"yd")</item> yields 57, his birthday was 57 days ago.</paragraph> </body> </helpdocument> |