I need to filter the overnight transaction (number of days equal to one working day ). in my dataset I have the start date column and end date column, I need to calculate number 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.
I tried to calculate this by calculating the weekend days and deduct the number , but I didnt get the idea deal with holidays.
Mohamed Aathif is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2