Workday/Holiday Macro

[itsmillrtme]

I need assistance in creating a macro removing holidays and weekends from my data. I have a list of the holidays I need to remove (from 2006-2016) and have columns in which I already removed weekends, manually. I have an image of the sample data if needed, but am unable to attach. Any help is greatly appreciated.

 

[Derek Brown]

Hello and welcome to The Board.
You can use the Excel NETWORKDAYS function for this.
Have a look at https://www.youtube.com/watch?v=DUg_C51Kyoo