Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be see if this helps
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
Did you see rbecher's response to do this in the script
Go through the same blog, there is one more solution mentioned in the bottom without macros.