https://bugs.documentfoundation.org/show_bug.cgi?id=153068
Bug ID: 153068
Summary: DATEVALUE function doesn't convert MM DD, YYYY format
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have imported a table of dates in the US format, e.g. May 16, 2023. I have
tried splitting this into separate month, day, year, fields, but then there's
no way of converting the month ("May") to a value. One trick from Excel doesn't
work either.
https://officetuts.net/excel/formulas/change-month-from-text-to-number/
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)
3.
Actual Results:
Err:502
Expected Results:
A date value
Reproducible: Always
User Profile Reset: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
