| View previous topic :: View next topic |
| Author |
Message |
Be4Truth
General User
Joined: 29 Mar 2005
Posts: 26
Location: South India
|
 Posted: Tue Oct 31, 2006 6:43 am Post subject: How to tell Calc that NETWORKDAYS function includes Saturday |
 |
|
Fedora Core 5
KDE 3.5.4-0.5.fc5
OpenOffice 2.0.4
In many developing countries Saturday is still a workday. It is therefore desirable to be able to tell the NETWORKDAYS function that a week has either 5 or 6 working days. Any idea? In my KDE general settings this is set but OOo doesn't check this (Why should it?).
Thanks for help in advance
Be4Truth |
|
| Back to top |
|
 |
davidh182
OOo Advocate
Joined: 01 Apr 2004
Posts: 413
|
| Posted: Tue Oct 31, 2006 9:03 am Post subject: |
|
|
The following should count up saturdays:
| Code: |
function count_saturdays(d1,d2)
count_saturdays=int((d2+7)/7)-int((d1+6)/7)
end function
|
Doesn't seem to be an option for this in OO. It would be quite easy for the developers to put in an optional true/false parameter for including Saturdays. You can request this... |
|
| Back to top |
|
|
|
