Log In
Register
Home
October 13, 2020
Offline
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.
Trusted Members
December 20, 2019
Offline
Can you please post an example so we can see what it is doing and how?
VIP
Trusted Members
December 7, 2016
Offline
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.myonlinetraininghu.....ower-query
Br,
Anders
1 Guest(s)
