Counting business days

[JZB]

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

[Bob Phillips]

The business days in a month can be calcukated with this formula

=NETWORKDAYS(TODAY()-DAY(TODAY()),TODAY())

[JZB]

Thats perfect thanks

As you can probably tell i am not too good with date formulae

Is there a formula to always show the 1st of the month in a cell. So only changing every month from, for example, 01/07/2009 to 01/08/2009 when we move into Aug?

simple i know but not sure :dunno

[mdmackillop]

=DATE(YEAR(NOW()),MONTH(NOW()),1)

[Bob Phillips]

=TODAY()-DAY(TODAY())+1