Here is a 200 years calendar that can display the dates between years 1900-2100. All you need to do is to change year from the spin buttons located on top.
I’ve hid the formulas for convinience. Worksheet is protected but without a password. So you can unprotect it and than can check the formulas if that interests you.
You can download it from here.
Learn about Excel with 24 easy slides!