I need a custom networkdays VBA function

[Worf99]

Hello everyone.
I'm from Italy and I need to calculate working days taking into account Saturdays and Sunday but also Italian festivities:


Januay 1st - New Year
January 6h - Epiphany
April 25h - Liberation
May 1st - Labour day
Monday of Easter (variable day, of course)
June 2nd - Republic Day
August 15th - Ferragosto
November 1st - All Saints
December 8th - Immaculate Mary
December 25th - Christmas
December 26th - Saint Stephen




The Excel formula "networkdays" can include a list of custom holidays (but I have to manually add that and also Monday Easter is variable) so I would prefer a VBA function that works regardless of the year of the two dates (start/end).


Thanks for every help!


Matteo

 

[Worf99]

I found what I needed here

https://www.excelvba.it/Forum/story...lications/Festivi_e_finesettimana_italia.html

I close the thread.