I am preparing an invoice template which has different rates depending on whether the shift started on a weekday, weekend or a public holiday.
I have a list of Western Australian holidays set up:
| date | serial no of date | hourly rate |
| date | serial no of date | hourly rate |
| date |...