Tying a monthly calenda to one cell

Hello to everyone reading this thread

I was wondering if it's possible to tie a calendar to one cell.

Say for instance: A1 is 2023

From A2 till Z2 are dates (A2 is the 01.01.2023 and Z2 is 26.01.2023)

Is it possible for the calendar to change just by changing the year in A1?
Like i type 2024 and then all dates from A2 to Z2 change accordingly.

Thank you very much!

I would highly appreciate it

Thank you for your answer!
But when i do that i end up with 2024 in A2.
My wish is to change A1 which is the year and the rest will automatically change.

Thank you so much!
This is what i want (i mean the idea of it).
But still can't apply it.
I have attached a file here, and what i wanna achieve is make the cells from F8 to M8 tied to E5.
so that when i change E5 to 2024 all of the cells change as well.
In the excel file attached, the dates where typed manually.
Last question maybe, how can i highlight the weekends (sat-sun) and the holidays (found on the second sheet) in grey? -the idea is to highlight all the vertical cells under the weekend or holiday.
i would greatly appreciate the help
Thanks a lot!

Use this formula in F8:

=DATE(E5,1,1)

and this one in G8:

=F8+1

Then you can copy G8 across as far as you need to.

To highlight weekends, you can use this formula:

=WEEKDAY(F$8,2)>5

in a Conditional Formatting rule, i.e. select all the cells that you want this to apply to (e.g. from F8 across and down), then click on Conditional Formatting | New Rule | Use a formula... , then put that formula in the box which pops up and click on the Format button | Fill tab and choose your colour, then OK twice to exit the dialogue box.

Hope this helps.

Pete

If you want to show holidays in the same colour as the weekends, you can amend the CF formula to this:

=OR(WEEKDAY(F$8,2)>5,COUNTIF(Holidays!$B:$B,F$8))

Hope this helps.

Pete