https://bugs.documentfoundation.org/show_bug.cgi?id=170543
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #3 from Mike Kaganski <[email protected]> --- This is not a bug. TEXT(...; "mmmm") does *not* give you a "name for a month number". I.e., its result is *not* expected to be "1 -> January", "2 -> February", ... "12 -> December". No, this is a *wrong* expectation. What is *is* expected to produce, is "take the number from the first argument, consider is as a *date*, find that date's month, and show it as text". Specifically, dates in Calc are represented as (maybe fractional) number of days since "epoch" - usually since 1899-12-30. That means, that number 0 means "date 1899-12-30"; number 1 means "1899-12-31"; number 2 means "1900-01-01" ... and so on. Note that "number 1" is still in December 1899, and numbers 2 to 32 are all in January 1900. Your formulas in column C should NOT be =TEXT(MONTH(date);"mmmm") - it should be =TEXT(date;"mmmm"). -- You are receiving this mail because: You are the assignee for the bug.
