<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#c4">Comment # 4</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>My apologies Mike, I have finally realised that what appeared to be the correct return of the month number was simply because I was "pre-loading" the result I expected into the formula and that it simply performed the HLOOKUP() on a foregone conclusion. Formatting the date cell to simply display the month allowed me to mislead myself into believing the HLOOKUP was on the month descriptor instead of the preloaded month number.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>