https://bugs.documentfoundation.org/show_bug.cgi?id=118700
Bug ID: 118700
Summary: WeeksinYear function in error
Product: LibreOffice
Version: 5.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bob.bro...@cox.net
Description:
I used the example in the documentation =WEEKSINYEAR(1970-2-17). This should
have produced 53 but it produced 52. In fact I tried every years for about a 10
year period and always got 52. 53 should occur about every 4 or 5 years. I used
cell A1.
Also is there some way to change the default Date format to 02/17/1970?
Steps to Reproduce:
=WEEKSINYEAR(1970-2-17) in any cell
2.
3.
Actual Results:
52
Expected Results:
53
Reproducible: Always
User Profile Reset: Yes
Additional Info:
WEEKSINYEAR
Calculates the number of weeks of the year in which the date entered occurs.
The number of weeks is defined as follows: a week that spans two years is added
to the year in which most days of that week occur.
Syntax
WEEKSINYEAR(Date)
Date is any date in the respective year. The Date parameter must be a valid
date according to the locale settings of LibreOffice.
Example
WEEKSINYEAR(A1) returns 53 if A1 contains 1970-02-17, a valid date for the year
1970.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
