How to calculate workday

Discuss the spreadsheet application
Post Reply
faried
Posts: 3
Joined: Fri Mar 08, 2019 5:28 am

How to calculate workday

Post by faried »

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

Re: How to calculate workday

Post by Villeroy »

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 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: How to calculate workday

Post by RusselB »

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, 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.
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: How to calculate workday

Post by gerard24 »

LibreOffice 6.4.5 on Windows 10
faried
Posts: 3
Joined: Fri Mar 08, 2019 5:28 am

Re: How to calculate workday

Post by faried »

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

Post by faried »

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 77 times
Apache OpenOffice 4.1.2
Post Reply