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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118700

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #2 from m.a.riosv <miguelangelrv at libreoffice.org> ---
=WEEKSINYEAR(1970-2-17) uses the date for value 1951, calc value for the date
1905/05/04

Like raal have done on comment#1, dates in a function must be used with the
value in calc for the desired date or the date inside quotes, the more secure
introducing the date with DATE(YY;MM;DD) function if it is not referenced to
other cell with the date.

About the format it depends on the language, Menu/Tools/Options/Language
settings/Language

-- 
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/4b36771d/attachment.html>