I need a custom networkdays VBA function

Worf99

New Member
Joined
Jan 13, 2018
Messages
40
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,109,493
Messages
5,529,187
Members
409,856
Latest member
MAO
Top