There is Sleep As Android that reads google calendar to turn alarm off on statutory holidays and your personal days off if you put
#holiday into a full day event title.
Some statutory holidays may not apply to you. For example in Alberta Medical Aide Day is October 18, 2018 but my workplace (like most places) is not giving it as a paid day off. As such I can put
#notholiday into the title of an all day event in Google Calendar for October 18, 2018.
To read more see: Sleep as Android: Sleep cycle tracker, smart alarm
It's hard to image no one has come up with the ability to turn off the regular Monday to Friday Google Android Alarm Clock based on Google Android Calendar stat holidays plus any vacation days and personal days you add to the calendar.
Reply to comments: Having used up all my points on bounty, I no longer have sufficient rep to reply to comments. To @beeshyams
The link states:
Ever been roused from a good, deep sleep on a public holiday because the alarm clock wasn't turned off? AMdroid knows the public holidays for your country; alarms wonxe2x80x99t go off on these days (optional).
I'm not sure what "optional" means. Plus there is no mention of your days off (vacation, personal days, summer floats, winter floats, birthday, etc.)