<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - CALC MONTH(TODAY)) producing incorrect Descriptor which is exacerbated by adding the value of a reference cell" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139510#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - CALC MONTH(TODAY)) producing incorrect Descriptor which is exacerbated by adding the value of a reference cell" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139510">bug 139510</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>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?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>