Calculating working days in a week

[pf36]

For any given period I wish to calculate the number of working days (monday to friday only). I'm receiving an item for processing on a weekday and I want to calculate the processing time excluding the weekend periods.

In addition if I receive something for processing after 15:30 it is classed as the following day arrival.

Thanks

Eg1 29/09/2011 to 04/10/2011 = 4 working days
Eg2 29/09/2011 15:31 classed as receiving 30/09/2011

 

[VoG]

Try

=NETWORKDAYS(A1,B1)

In Excel 2003 and earlier this requires the Analysis Toolpak (from Tools > Add-ins).

 

[barry houdini]

Assuming you have date and time in the same cell then you can amend VoG's suggestion to get your "next day" stipulation

=NETWORKDAYS(A1-"15:30"+1,B1)