[Libreoffice-bugs] [Bug 139510] CALC MONTH(TODAY)) producing incorrect Descriptor which is exacerbated by adding the value of a reference cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Colin <that.man.colin at gmail.com> ---
In all honesty, I only needed the month number returned by MONTH(TODAY()) so I
could identify a sequential column alpha for an INDIRECT().
In order to verify that it would return the correct month number as time
progressed, I simply added the variable to verify my logic.
I (mistakenly?) believed I would be incrementing the month number but as you
explained, with your explanation of epoch, I was just adding single days to the
date.
Is this still possibly a bug because the MONTH(TODAY()) correctly returns month
number 1 so shouldn't my extra number be incrementing the return of the "outer
wrapper" - MONTH() function - as opposed to the "inner" TODAY() function?
That is to say; the returned value was =TODAY()+1 when surely the expectation
is =MONTH()+1
Or is this really a topic for Ask Libre?

-- 
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/20210109/e691c1be/attachment.htm>