Use of Macro to count number

[Sagar100]

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!

[raypayette]

Of course a macro could do this, but I don't see the point when you have formulas that do it automatically! Perhaps your formulas are incomplete? This should be completely automatic.

[Sagar100]

I apologize. I could not express my problem well. It is like that in first two columns, in every month there are more than 100 rows of date entries. To determine the difference of these two dates, for every month, I have to type/paste the NetWorkingDays formula in every rows of third column. My thinking is that can we automate this so that as soon as I enter a date in a row of second column(assuming that first row date column has already been entered), the third corresponding row column will automatically be filled in with a macro?

I would appreciate help from any of you!

[raypayette]

The usual practice is to copy the formula from one cell perhaps to the whole column!

[Sagar100]

Ray, thanks for your inputs. I was thinking there would be other way out. If this is the right way, then every monty, I will copy and paste in every row of the column.
Once again thanks!