Hi how to count the days from a date picker from and date picker to excluding weekends and public holiday?
I assume that I need to create a list of all public holidays.
I have seen a similar thread about this issue, the thread link is:
Please try to function provided in the thread to see if it will work for you.
Please feel free reply if you need more help.
Yes, you'll need to create a list of holidays - as this value is different not only between countries, but also between regions (states, cities, etc.) within a single country.
The post at https://blogs.msdn.microsoft.com/carlosfigueira/2017/09/23/excluding-weekends-and-holidays-in-date-d... shows how you can exclude weekends and holidays when calculating the difference between two dates.