func_days.xhp (54be4dae) | func_days.xhp (a9e83bba) |
---|---|
1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 19 unchanged lines hidden (view full) --- 28<filename>/text/scalc/01/func_days.xhp</filename> 29</topic> 30</meta> 31<body> 32<bookmark xml-lang="en-US" branch="index" id="bm_id3151328"> 33<bookmark_value>DAYS function</bookmark_value> 34</bookmark> 35<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/> | 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 19 unchanged lines hidden (view full) --- 28<filename>/text/scalc/01/func_days.xhp</filename> 29</topic> 30</meta> 31<body> 32<bookmark xml-lang="en-US" branch="index" id="bm_id3151328"> 33<bookmark_value>DAYS function</bookmark_value> 34</bookmark> 35<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAGE" id="bm_id3148893" localize="false"/> |
36<paragraph role="heading" id="hd_id3151328" xml-lang="en-US" level="2" l10n="U" oldref="116"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link></variable></paragraph> 37<paragraph role="paragraph" id="par_id3155139" xml-lang="en-US" l10n="CHG" oldref="117"><ahelp hid="HID_FUNC_TAGE">Calculates the difference between two date values.</ahelp> The result returns the number of days between the two days.</paragraph> 38<paragraph role="heading" id="hd_id3155184" xml-lang="en-US" level="3" l10n="U" oldref="118">Syntax</paragraph> 39<paragraph role="code" id="par_id3149578" xml-lang="en-US" l10n="U" oldref="119">DAYS(Date2; Date1)</paragraph> 40<paragraph role="paragraph" id="par_id3151376" xml-lang="en-US" l10n="U" oldref="120"> 41<emph>Date1</emph> is the start date, <emph>Date2</emph> is the end date. If <emph>Date2</emph> is an earlier date than <emph>Date1</emph> the result is a negative number.</paragraph> 42<paragraph role="heading" id="hd_id3151001" xml-lang="en-US" level="3" l10n="U" oldref="121">Examples</paragraph> 43<paragraph role="paragraph" id="par_id3159101" xml-lang="en-US" l10n="CHG" oldref="123">=DAYS("2010-01-01"; NOW()) returns the number of days from today until January 1, 2010.</paragraph> 44<paragraph role="paragraph" id="par_id3163720" xml-lang="en-US" l10n="CHG" oldref="172">=DAYS("1990-10-10";"1980-10-10") returns 3652 days.</paragraph> | 36<paragraph role="heading" id="hd_id3151328" xml-lang="en-US" level="2" l10n="U"><variable id="days"><link href="text/scalc/01/func_days.xhp">DAYS</link></variable></paragraph> 37<paragraph role="paragraph" id="par_id3155139" xml-lang="en-US" l10n="CHG"><ahelp hid="HID_FUNC_TAGE">Calculates the difference between two date values.</ahelp> The result returns the number of days between the two days.</paragraph> 38<paragraph role="heading" id="hd_id3155184" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 39<paragraph role="code" id="par_id3149578" xml-lang="en-US" l10n="U">DAYS(Date2; Date1)</paragraph> 40<paragraph role="paragraph" id="par_id3151376" xml-lang="en-US" l10n="U"><emph>Date1</emph> is the start date, <emph>Date2</emph> is the end date. If <emph>Date2</emph> is an earlier date than <emph>Date1</emph> the result is a negative number.</paragraph> 41<paragraph role="heading" id="hd_id3151001" xml-lang="en-US" level="3" l10n="U">Examples</paragraph> 42<paragraph role="paragraph" id="par_id3159101" xml-lang="en-US" l10n="CHG">=DAYS("2010-01-01"; NOW()) returns the number of days from today until January 1, 2010.</paragraph> 43<paragraph role="paragraph" id="par_id3163720" xml-lang="en-US" l10n="CHG">=DAYS("1990-10-10";"1980-10-10") returns 3652 days.</paragraph> |
45</body> 46</helpdocument> | 44</body> 45</helpdocument> |