Using NETWORKDAYS function in a report.

[Ralph43065]

I'm trying to use the NETWORKDAYS function in a text box on a report to calculate the number of workdays (weekends excluded) between 2 date fields ("DateBPInfoRecd" and "DateBPIssued&quot of a query that the report is generated from. Both of the query date fields appear in the report, and the query prompts the user to enter starting and ending dates for the "DateBPIssued" field to select the particular records. I want the NETWORKDAYS function to then calculate the number of workdays between the 2 dates for each record on the report.

On the report, I've tried entering the NETWORKDAYS function in the Control Source of a report text box as follows:

=NETWORKDAYS([DateBPInfoRecd],[DateBPIssued])

When I try to run the query/report, I am prompted for the starting and ending dates for the “DateBPIssued” field (as expected). I’m then prompted for another parameter input under “NETWORKDAYS” (not expected). When I try to either leave the NETWORKDAYS prompt blank or fill in a date, I generate a blank report.

Any help in understanding how to use the NETWORKDAYS function would be greatly appreciated.

 

[MichaelRed]

I think (therefore ... ) Network days is an Excel function. It really doesn't matter, as it suffers from the lack of holidays -which ALWAYS announce their presence (or lack thereof) in a professional app.

faq181-261, however, has the complete soloution -although it DOES require some ongoing maintenance of the holiday schedual.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places