https://bugs.documentfoundation.org/show_bug.cgi?id=161591
Bug ID: 161591
Summary: Formula Error in Calc
Product: LibreOffice
Version: 25.2.0.0 alpha0+
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In calc when you use YEARFRAC and you have dates such as 12 Jan, 2020 in one
cell and 20 Jun, 2020 in another cell, it should return 5.27.
The actual formula would be =yearfrac(A2,B2)*12.
When this is entered, it returns an error.
That being said, if your dates are formatted as say, 04/02/2017, the formula
works. It will work when there is a shortened month, such as APR, MAR, FEB,
JAN.
Actual Results:
#VALUE
Expected Results:
5.27
Reproducible: Always
User Profile Reset: No
Additional Info:
I can be reached at [email protected]
--
You are receiving this mail because:
You are the assignee for the bug.
