How to calculate workday

Discuss the spreadsheet application

How to calculate workday

Postby faried » Fri Mar 08, 2019 5:41 am

Hi guys
need some advice

Im using Apache OpenOffice 4.1.2

Im looking similar formula like WORKDAY.INTL in Libre/Excel

I need to calculate " Received Date" from the " Posting Date "

" Posting Date " + SLA - Weekend - Public Holiday ( certain state got diff weekend ( Sat&Sun / Fri&Sat ) and diff Public Holiday )
Apache OpenOffice 4.1.2
faried
 
Posts: 3
Joined: Fri Mar 08, 2019 5:28 am

Re: How to calculate workday

Postby Villeroy » Fri Mar 08, 2019 2:48 pm

Simply drop OpenOffice and install LIbreOffice.
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: 27214
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to calculate workday

Postby RusselB » Fri Mar 08, 2019 3:38 pm

Welcome to the Forums.
The easiest method is to use LibreOffice, as you already know the function exists there.
If you want to do this with OpenOffice, it's going to be a lot more complicated, but can be done.
OpenOffice 4.1.7 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: 5498
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: How to calculate workday

Postby gerard24 » Fri Mar 08, 2019 5:10 pm

LibreOffice 6.2.4 on Windows 10
gerard24
Volunteer
 
Posts: 949
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: How to calculate workday

Postby faried » Fri Mar 15, 2019 2:35 am

sorry gerard24, can you check your inbox
Apache OpenOffice 4.1.2
faried
 
Posts: 3
Joined: Fri Mar 08, 2019 5:28 am

Re: How to calculate workday

Postby faried » Wed Mar 20, 2019 7:39 am

sorry gerad

i still dont know where to edit the formula
i delete other formula and leave only for " with holiday "
i copy my public holiday and replace with yours, and it only calculate up to row 29 only even tho i set the formula up to row 36

and can i read the public holiday from different sheet
Attachments
CustomWorkday.ods
(23.81 KiB) Downloaded 9 times
Apache OpenOffice 4.1.2
faried
 
Posts: 3
Joined: Fri Mar 08, 2019 5:28 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 31 guests