Good day
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.
Can you please post an example so we can see what it is doing and how?
Hello Keith,
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.myonlinetraininghub.com/getting-started-with-apis-in-power-query
Br,
Anders
