JZB
07-15-2009, 10:50 AM
Hi guys
I have a total charge number that i wish to turn into a daily number: so charge/number of business days
However i have no idea how to attain the amount of business days gone in the month.:dunno
I currently have the business date -1 in cell A1
Range("a1").Formula = "= WORKDAY(TODAY(), -1)"
I assume i can use this variable
Sorry guys bit stuck on this one:help
Thanks
Jon
I have a total charge number that i wish to turn into a daily number: so charge/number of business days
However i have no idea how to attain the amount of business days gone in the month.:dunno
I currently have the business date -1 in cell A1
Range("a1").Formula = "= WORKDAY(TODAY(), -1)"
I assume i can use this variable
Sorry guys bit stuck on this one:help
Thanks
Jon