How To Put The Names Of The Current Month's Holidays On My Calendar With VBA

[A.Maurizio]

Ciao a tutti da Maurizio, vi scrivo perchè ho un problema che mi sta facendo impazzire ovvero questo:

Sul Foglio 2 di Excel vorrei poter inserire i nomi delle festività Attuali prendendo i dati dalla cella (H2:I21) 
ed inserire i nomi delle festività nelle Celle sopra del mio Calendario che si trova a partire dalla celle (Q3:W8)
Tenendo sempre presente che ad ogni mese dell'anno corrispondono nuove festività con le loro variazioni  

Ho provato a scrivere questa funzione ma non riesco a farla funzionare e non capisco perché.
Questo è tutto. Grazie mille A.Maurizio

Buone vacanze a tutti 

Mio_Progetto_Calendar.xlsx.xlsm

Editado el el 26 de diciembre por A.Maurizio

[Antoni]

El calendario se calcula automáticamente a partir de la cela Q1.

En Q3 hay una llamada a la UDF FirstMonthMonday.

Hay 2 formatos condicionales para marcar las fechas fuera del mes.

Abre el adjunto y pulsa sobre el "botón" Trova Date.

Mio_Progetto_Calendar.xlsx.xlsm

[A.Maurizio]

Hi Antoni Sorry if I'm only writing to you today but I've been busy all this time with celebrations, preparations and work.

Having said that, as always you were sublime to say the least.

As your project is as beautiful as ever; although to be honest I will have to try to make some changes as I will have to try to connect your date with my 2023
so that when I enter my ("023) that you find in cell (I1) I can also change your (Date - Today()) that you put in cell (Q1) because by doing this I can do a whole series of other operations such as automatically updating all the dates with the new year of the column (H2:H21) which among other things I have already done and it works very well, but I wasn't able to show it to you in full because I don't have your download portal allowed because it considers it too large a file, which is why I only gave you a part of it.

But with you in all these years I have learned a lot so I don't think I will find many difficulties in realizing everything.

Therefore I wish you and your family and all your staff Happy Holidays and a Very Happy New Year 2024
With Sympathy and Friendship Happy Holidays to Everyone from A.Maurizio
Thanks thanks thanks

[A.Maurizio]

Hello Everyone from A.Maurizio. I am writing to you only because I have seen the Italian Channels these days and I was shocked by the flood and came to Valencia and its surroundings. Therefore, being one of your members on the Excel Help Forum and an acquaintance of Antonio and others, I wanted to know how they are. That's all. Thank you. Greetings to everyone and good work from A.Maurizio