diff options
| author | Andras Timar <atimar@suse.com> | 2012-06-13 20:23:57 +0200 |
|---|---|---|
| committer | Andras Timar <atimar@suse.com> | 2012-06-13 20:24:41 +0200 |
| commit | 7369aa5d72c8b86f8ee483e9eaf55d72deec1ea4 (patch) | |
| tree | 0be36181db76fafe2dd386061250333aa50e3392 /helpcontent2 | |
| parent | c64e706d3cf2d8dfcdfb22886c2d3345baed2306 (diff) | |
DATE -> DATEDIF
Change-Id: Ia11b79db360698f0d5122d0640716985fc7df037
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> |