Discussion Locked

How to exclude weekends when counting da

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Excel I have a need to count the days from today back to a cell reference and then use that value to divide into a count of records (records per day...). What I can't seem to figure out is how to count only the weekdays in this range since records are not created on weekends. Any ideas?

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.