4 replies
by mightyduk
If you have named range records and named range days:
sum(records)/(count(days)*5/7)
If you have one range of fields with the quantity of records for each day, you could simply use:
sum(records)/count(records)
If this doesn't answer the question, you should clarify what the layout of the spreadsheet is.
by larry h.
You can also load in the Analysis Toolpack, which contains a function that can do this for you. It is called =NETWORKDAYS(Start_Date, End_Date) and has an option to also exclude holidays if you need to.
Go to TOOLS, ADD-INS.
Choose the ANALYSIS TOOLPACK and click OK (You'll probably need your Office CD at this point).
See Excel's Help files for more info.
This discussion is closed to new replies.
Trending Desktop posts
Sort by Trending