Network Days

[vy]

I need help calculating Network Days in Access 2003. The formula I use in
Excel is

= (Monthly Quota/NETWORKDAYS (Beginning of Month, End of Month))*NETWORKDAYS
(Beginning of Month, TODAY ()-1)

The Beginning of the Month and End of Month I pull from a column with just
those two dates for the month. And then each month I change the month and
Days.

How can I calculate Network days in Access? I do I put this in code? If so
how (Because I don't know) and do I manually put the dates in the query
fields or will the calculate some how? Please help.

 

[Clifford Bass]

Hi,

I am somewhat unclear as to what you are doing there. Anyway, you can
use these to get the values you desire:

Today: Date()
Beginning of Month: DateSerial(Year(Date()), Month(Date()), 1)
End of Month: DateSerial(Year(Date()), Month(Date()) + 1, 0)

DateSerial is a flexible function in that you can give it "invalid"
values and it adjusts for them. So DateSerial(2009, 13, 0) will give you the
thirteenth month in 2009 (January 2010) and then the zeroth day of that
month; which is December 31, 2009.

This can be used either in a query or in code.

Hope that helps,

Clifford Bass

 

[vy]

Hi Clifford,

I am trying to calculate sales quota for each day of the month vs. actual
sales for each day of the month. I would like for the formula to calculate
how the Sales percentage for each day.

Let's say there are 20 business days in the month. And we are on day 15. I
would like to calculate where we stand in sales vs. quota up to day 15.

 

[Clifford Bass]

Hi,

As I am not in sales, could you be more specific? Maybe provide a
sample of the data you might have and what the expected results would be?
Tell me how you know that there are 20 business days in the month (does that
vary?). And tell how you know get the current business day.

Clifford Bass