Network Day without Saturday

[pandiarajan]

Dear All,

As my current client requirement, I want to calculate monthly project of the sales. They are given a specific list of Public holiday list based on I need to calculate how many working days between the particular time period.

As I used Network day function I could be able to exclude Saturday, Sunday and my public holiday. But my client requirement we need only exclude Sunday and list of a public holiday.

Kindly someone suggests me the good solution ]

Thanks & Regards,

Pandiarajan.R

[sunny_talwar]

May be see if this helps

Networkdays with saturday

[pandiarajan]

Hi Sunny ,

     Thank You for Your Solution!

I wanted to Exclude list of the Public holiday as well as . one more thing Is there any other alternate solution to solve this issue because of My solution architect not accepting Macro code

Thanks & Regards,

Pandiarajan.R

[sunny_talwar]

Did you see rbecher‌'s response to do this in the script

Re: Networkdays with saturday

[jyothish8807]

Go through the same blog, there is one more solution mentioned in the bottom without macros.