Network Days or Business Days Calculation

Question

Summary: Looking for advice on how to calculate network/business days.

In excel it's super easy to calculate business days / holidays by using the networkdays function, in oracle not so much. Does anyone know how to calculate

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Gianni Ceresa · Answer

As there isn't a function doing that in one step, you need to get there by some logical operations. There is a function calculating the number of days between 2 dates, that same function can give you also the number of weeks between 2 dates (or you can take the days / 7). You then only need to adjust things a bit to cover the cases of adding or removing a few days depending on the 2 dates itself.

It is really a full expression that you will need in your formula: break it down into pieces adding the required extra bit to get closer and closer to the exact result.

Or, as said, implement a proper time dimension...

DiDio · Answer

@Gianni Ceresa @Michal Zima  and everyone thank you for the kind responses. So by business days I mean in the U.S and simply put for now I'd like to exclude Sat/Sun from the calculation.

So if i have a date of 6/7/2022 and another date of 6/15/2022 the count of days should be 7 days because i'm excluding sat/sun.

Keeping it as simple as that for now. Holidays are another scenario and not as important to the calculation.

This would be a newly created column in the data within OAC.

Michal Zima · Answer

Completely agree with @Gianni Ceresa - this should be "handled" in data - thus designing (and populating) your time dimension in database as per your business requirements. And then every BI/Data visualization tool can benefit from it.