Bug 130467 - error in DIA.LAB (DIAS.LAB)
Summary: error in DIA.LAB (DIAS.LAB)
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-05 18:01 UTC by jrmania@gmail.com
Modified: 2020-02-06 22:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Sample file. (13.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-05 21:34 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jrmania@gmail.com 2020-02-05 18:01:55 UTC 
Description:
the function DIA.LAB error in number days intro DATES. 
the DATE is 19 days and the real days is 20 if you count in the calendar.
example:
A2:thursday 10/march/2020 ; C2:19 ; RESULT: monday 06/march/2020 apply =DIA.LAB(A2;C2) result 19days to monday 06/march/2020 if you count in the calendar is 20days.

to corrected the result i sum +1 day in the formula...=DIA.LAB(A2;C2)+1





Actual Results:
A2:thursday 10/march/2020 ; C2:19 ; RESULT: monday 06/march/2020 apply =DIA.LAB(A2;C2) result 19days to monday 06/march/2020 if you count in the calendar is 20days.

to corrected the result i sum +1 day in the formula...=DIA.LAB(A2;C2)+1

Expected Results:
A2:thursday 10/march/2020 ; C2:19 ; RESULT: monday 06/march/2020 apply =DIA.LAB(A2;C2) result 19days to monday 06/march/2020 if you count in the calendar is 20days.

to corrected the result i sum +1 day in the formula...=DIA.LAB(A2;C2)+1


Reproducible: Always


User Profile Reset: No



Additional Info:
PLEASE CORRECTED...

I LOVE LIBREOFFICE...
Comment 1 m_a_riosv 2020-02-05 21:34:30 UTC 
Created attachment 157678 [details]
Sample file.

I don't find where the issue can be, if there is one.
10/03/20		
1	11/03/20	mié
2	12/03/20	jue
3	13/03/20	vie
4	16/03/20	lun
5	17/03/20	mar
6	18/03/20	mié
7	19/03/20	jue
8	20/03/20	vie
9	23/03/20	lun
10	24/03/20	mar
11	25/03/20	mié
12	26/03/20	jue
13	27/03/20	vie
14	30/03/20	lun
15	31/03/20	mar
16	01/04/20	mié
17	02/04/20	jue
18	03/04/20	vie
19	06/04/20	lun

Attached file with the two functions for that.
Comment 2 jrmania@gmail.com 2020-02-06 18:53:43 UTC 
ok... 
10/03/20 is the first day and 06/04/20 is the end day. the result is 20 days.





Both dates must be included to calculate vacations for example.
Comment 3 m_a_riosv 2020-02-06 22:30:25 UTC 
Sorry but one day plus one it's the next day.

In fact if you use =NETWORKDAYS.INTL(A1;B20) in the sample file the result it's 20, because it counts the working days between two dates, and both are counted.