From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- .../source/text/scalc/01/func_yearfrac.xhp | 100 +++++++++++++++++++++ 1 file changed, 100 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/func_yearfrac.xhp (limited to 'helpcontent2/source/text/scalc/01/func_yearfrac.xhp') diff --git a/helpcontent2/source/text/scalc/01/func_yearfrac.xhp b/helpcontent2/source/text/scalc/01/func_yearfrac.xhp new file mode 100644 index 000000000..135192689 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_yearfrac.xhp @@ -0,0 +1,100 @@ + + + + + +YEARFRAC +/text/scalc/01/func_yearfrac.xhp + + + +YEARFRAC function + + +

YEARFRAC

+The result is the number of the years (including fractional part) between StartDate and EndDate. + + +YEARFRAC(StartDate; EndDate [; Basis]) + +StartDate and EndDate are two date values. +
+ +Basis (optional) is chosen from a list of options and indicates how the year is to be calculated. + + + +Basis + + +Calculation + + + + +0 or missing + + +US method (NASD), 12 months of 30 days each + + + + + 1 + + +Exact number of days in months, exact number of days in year + + + + + 2 + + +Exact number of days in month, year has 360 days + + + + + 3 + + +Exact number of days in month, year has 365 days + + + + + 4 + + +European method, 12 months of 30 days each + + +
+
+ + + +What fraction of the year 2008 lies between 2008-01-01 and 2008-07-01? +=YEARFRAC("2008-01-01"; "2008-07-01";0) returns 0.50. +
+ +
+ + -- cgit v1.2.3