https://bugs.documentfoundation.org/show_bug.cgi?id=153068
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #1 from ady <[email protected]> --- (In reply to web from comment #0) > Steps to Reproduce: > 1. Enter a text date such as "May 16, 2023" in cell A1 > 2. In another cell enter the formula =DATEVALUE(A1) DATEVALUE(A1) expects text in A1, or as in DATEVALUE("May 16, 2023"), but your A1 is already a date (not text). If you type in B1: =MONTH(A1) you should receive a result of "5" (without quotation marks). Can you please confirm? -- You are receiving this mail because: You are the assignee for the bug.
