The add-in Adequate contains a wizard that allows you to show the holidays of a certain year.
What day of the week is Christmas and when is Easter? These questions are easily solved with this wizard. You fill in the year (or the cell containing the year) and press OK. You immediately see the answers to all of your questions.
You can also get an extended list by checking the box Extensive.