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 )
How to calculate workday
How to calculate workday
Apache OpenOffice 4.1.2
Re: How to calculate workday
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: How to calculate workday
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.
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.
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: How to calculate workday
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
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 80 times
Apache OpenOffice 4.1.2