October 13, 2020
I have created a custom function that determines if a particular date is a South African holiday or not. It works for multiple (20) years, including Easter weekends.
How can I include it for use in the Workday.intl function as the Holiday argument? This function requires a range or array in which the holidays are prescribed/listed, which requires quite a long list of you want to do this for 20 years.
My function's syntax is =PH(date) and returns the name of the holiday, but can easily be amended to provide a yes/no answer - which will make it quite simple. If interested, I can post the function's code.
Looking forward to a response.
December 20, 2019
December 7, 2016
Have you considered using holiday API's with Power Query to get a list of holiday dates?
One example of how to get data using API's is found here. https://www.myonlinetraininghu.....ower-query