WhereScape RED Builds data warehouses, fast.

I recently came across a useful Excel macro that calculates NZ holidays - I have adapted it to generate SQL to update our date dimension.  Feel free to contact us on support if you would like a copy.