|Total number of invoices should be a variable, getting its value from each days total (let's say variable A = total number of invoices)|
Total number of persons available should be also a variable. (variable B = total number persons)
The macro should run the math as A/B.
Not knowing exactly what you are doing (is this macro being used in an access database?) I can only give very basic advice. Post back with greater details of what you need.
Please let us know if you found someone's advice to be helpful.