PDA

View Full Version : Counting business days

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

Bob Phillips
07-15-2009, 12:40 PM
The business days in a month can be calcukated with this formula

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

JZB
07-16-2009, 03:52 AM
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
07-16-2009, 05:21 AM
=DATE(YEAR(NOW()),MONTH(NOW()),1)

Bob Phillips
07-16-2009, 05:51 AM
=TODAY()-DAY(TODAY())+1