https://bugs.documentfoundation.org/show_bug.cgi?id=157669
Bug ID: 157669
Summary: Formula not processing if correctly
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Date in cell A1: 11/26/23
Formula in cell B1: =IF(MONTH(A1)=MONTH(A1+7),B1+7,"")
Results shown in B1: 12/30/99
Tested formulas:
=month(A1) Result: 11
=month(A1+7) Result: 12
=A1+7 Result: 12/03/23
Steps to Reproduce:
Date in cell A1: 11/26/23
Formula in cell B1: =IF(MONTH(A1)=MONTH(A1+7),B1+7,"")
Results shown in B1: 12/30/99
Tested formulas:
=month(A1) Result: 11
=month(A1+7) Result: 12
=A1+7 Result: 12/03/23
Actual Results:
Date in cell A1: 11/26/23
Formula in cell B1: =IF(MONTH(A1)=MONTH(A1+7),B1+7,"")
Results shown in B1: 12/30/99
Tested formulas:
=month(A1) Result: 11
=month(A1+7) Result: 12
=A1+7 Result: 12/03/23
Expected Results:
Month in B1 should be 12/03/23
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.8
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
