Software·43,776 discussions

Calculating Networkdays in Access 2000

Locked

Hi,

I have three text box controls, OpenDate, CloseDate, NumDays. The OpenDate,
CloseDate controls are data/time fields and the NumDays is a number field.
Is there a way to use Expression builder to calculate the working days using
the function NETWORKDAYS?

I tried using it in this fashion, Control Source: = NETWORKDAYS (OpenData,
CloseDate) but I get #Name? as a result (I do have the correct dll file
installed for this function, MSOWCF.DLL)

I got to work fine in Excel, but not Access. I did not try doing in VB
because I’m not sure how to start the function. Any help is very much
appreciate it

Thank you

Topic

Calculating Networkdays in Access 2000

In reply to Calculating Networkdays in Access 2000

NumDays = [CloseDate] – [OpenDate]

Microsoft Access stores the Date/Time Vaiable as a Number.

There aree many methods available in addition to the above that can be found in on-line Help. (i.e., DiffDate)

Calculating Networkdays in Access 2000

In reply to Calculating Networkdays in Access 2000

Poster rated this answer

Calculating Networkdays in Access 2000

In reply to Calculating Networkdays in Access 2000

The Number of days is as the previous answer indicates, but that would be total days. What you then need to do is to take int(5/7 Numdays) + Numdays mod 7. This will give you the numver of days in whole weeks, and the number of days in the partial week. Now all you need is to figure for holidays(if this matters for you), and there you are.

Calculating Networkdays in Access 2000

In reply to Calculating Networkdays in Access 2000

Poster rated this answer

Calculating Networkdays in Access 2000

In reply to Calculating Networkdays in Access 2000

This question was closed by the author

[Author]

Replies