0

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.

  • What exactly do you need? Fill day and date? – Máté Juhász Sep 27 '16 at 9:32
  • Yes. To fill day and date but like it's in calendar for that month and year. – user596129 Sep 27 '16 at 9:35
  • 1
    Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?. – DavidPostill Sep 27 '16 at 9:38
1

You can achieve it with a few simple formulas:

  • Date for first day of the month:
    =DATE(B1,B2,1)
  • Rest of the dates:
    =IFERROR(IF(MONTH(B5)=MONTH(B5+1),B5+1,""),"")
  • Day names:
    =IFERROR(CHOOSE(WEEKDAY(B5,2),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"),"")

Fill the formulas down to 31 rows, it'll display only dates in the month, cells below will be empty.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.