Hi Guys, I would very much appreciate if you help me on this. I know for you people, this may be simple. But I am struggling with that.

I have two columns, where dates are entered for each month. In third column, I am determining the difference of these two column dates using, NetWorkDays function. At the end of month, I count how many are more than 1 day and how many are = 1 day. I am using CountIf function to do that. Now every month, I have to first determine NetWorkDays for each row from two columns and count above by CountIf function. Is there is any way I can use macro to determine NetWorkDays and also count at the end of each month instead of above!
Thanks in advance!