Calc has a WORKDAY function, which will calculate the date based on the number of workdays from another date.
Is there a function, or a method of entering the two dates, and getting the number of workdays.
Obviously if there are holidays they would have to be accounted for, but the WORKDAY function has that already incorporated as the 3rd parameter.
[Solved] Workdays
[Solved] Workdays
Last edited by RusselB on Mon Apr 08, 2019 6:36 pm, edited 1 time in total.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Workdays
https://wiki.openoffice.org/wiki/Docume ... S_function =NETWORKDAYS(date1;date2;[holidays]) => 42
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Workdays
Thanks
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.