Excel: Customize Yearly Calendar with Dropdown, Auto-Update Holidays & Weekend Shading

Hey.
In the attachment file in which something worked but I do not know how to do:
1. I would like to choose a year from the drop-down list and change the dates in my schedule
2. Saturdays and Sundays filled with color + additionally marked with a different color when the holiday falls in a given month
@editor

I played a little bit more and made a selection of the year and months from the list - it changes my schedule and colors
The only thing I do not know is how to enter here to mark the holidays ...
File:


Thanks in advance !.

krystex15 wrote:

1. I would like to choose a year from the drop-down list and change the dates in my schedule
2. Saturdays and Sundays filled with color + additionally marked with a different color when the holiday falls in a given month

2017-05-2..1).png Download (55.82 kB)
Is this the effect?

If so, please use the attachment.
grafikte...xlsx Download (24.86 kB)Points: 2 for user

BTW formatting holidays in the calendar you can do as shown https://www.elektroda.pl/rtvforum/topic3343649.html#16491345

Prot wrote:

krystex15 wrote:

1. I would like to choose a year from the drop-down list and change the dates in my schedule
2. Saturdays and Sundays filled with color + additionally marked with a different color when the holiday falls in a given month

Is this the effect?

If so, please use the attachment.


BTW formatting holidays in the calendar you can do as shown https://www.elektroda.pl/rtvforum/topic3343649.html#16491345

Hey, thanks to editing the first post, you probably added the answer at the same time
How can you look at how I've done it myself: (file attached).
I would like to select the year separately and the month separately. I do not know how to take your holidays for now (if your way here works, or it's done differently.)

krystex15 wrote:

if your way here works, or it's done differently

Well, unfortunately not

On my list are numerical values (dates) that are used in formulas for conditional formatting .

Your lists are of text type so you can not directly use their settings for calculated formulas

But you can always play in the conversions of texts by numbers

I mean, it would be enough to only make numbers in my sheet. They do not have to be marked with the color also of the days of the week (pn -pt).

#edit

If anyone can ask for the formula to be made? or a function that would color my falling Christmas in the schedule that I have already made

krystex15 wrote:

I would ask for the formula to be made? or a function that would color my falling Christmas in the schedule

In post # 2, I wrote to you:

Quote:

formatting holidays in the calendar you can do as shown https://www.elektroda.pl/rtvforum/topic3343649.html#16491345

However, if you have a problem using that solution and obtaining the same effect as in a screenshot:
2017-05...png Download (55.72 kB)
then take a look at the next modification of your solutions in Sheet3
grafikte...xlsx Download (32.07 kB)Points: 2 for user