Calculating penalty rates based on day of the week

That's perfect, thank you.

I thought I'd probably need to enter the public holiday hours/pay manually.

I have a list of public holidays for this spreadsheet:

2016
Monday, 1 August
Monday, 3 October
Sunday, 25 December
Monday, 26 December
Tuesday, 27 December

2017
Sunday, 1 January
Monday, 2 January
Thursday, 26 January
Friday, 14 April
Saturday, 15 April
Sunday, 16, April
Monday, 17, April
Tuesday, 25 April
Monday, 12 June

Where might I start to make a rule for public holidays?