[Solved] Workdays

Discuss the spreadsheet application

[Solved] Workdays

Postby RusselB » Mon Apr 08, 2019 3:38 pm

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.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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
RusselB
Moderator
 
Posts: 5391
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Workdays

Postby Villeroy » Mon Apr 08, 2019 3:47 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Workdays

Postby RusselB » Mon Apr 08, 2019 6:35 pm

Thanks
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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
RusselB
Moderator
 
Posts: 5391
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests