I need to filter the overnight transaction (no of days equal to one working day ). in my dataset I have the start date column and end date column, i need to calculate no of working days between them with eliminating the weekend and special holidays. please give me a solution in VBA for this by considering the holidays assign.
note – in my region has different holidays that not appear in the system calender.
thank you in advance!
I tried to calculate this by calculating the weekend days and deduct the number , but I didnt get the idea deal with holidays.
New contributor
Mohamed Aathif is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.