I need to fill in a Day and Date column in an Excel table to create a one month calendar:
Select a year: 2016
Select a month: September
-------------------------
| Day | Date |
|------------------------
|Thursday | 01.09.2016 |
|Friday | 02.09.2016 |
| etc. | etc. |
-------------------------
(Note the date format is dd.mm.yyyy.)
The days and dates must be calculated automatically after choosing year and month.