[Solved] Workdays

Discuss the spreadsheet application
Post Reply
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

[Solved] Workdays

Post by RusselB »

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.
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.
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Workdays

Post by Villeroy »

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
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Workdays

Post by RusselB »

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.
Post Reply