[Libreoffice-bugs] [Bug 130467] error in DIA.LAB (DIAS.LAB)

2020-02-06 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=130467

m.a.riosv  changed:

   What|Removed |Added

 Resolution|--- |NOTABUG
 Status|UNCONFIRMED |RESOLVED

--- Comment #3 from m.a.riosv  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 130467] error in DIA.LAB (DIAS.LAB)

2020-02-06 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=130467

--- Comment #2 from jrma...@gmail.com  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 130467] error in DIA.LAB (DIAS.LAB)

2020-02-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=130467

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #1 from m.a.riosv  ---
Created attachment 157678
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157678=edit
Sample file.

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

Attached file with the two functions for that.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs