[Libreoffice-bugs] [Bug 118700] New: WeeksinYear function in error

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: bob.brooks at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180711/4fea5790/attachment.html>