Microsoft Office Tutorials and References
In Depth Information
The NETWORKDAYS function returns the number of working days between two dates. Excludes
weekends and specified holidays.
The NETWORKDAYS function allows you to find out the total number of working days between
two dates excluding the weekends and holidays. This is an extremely important function
when calculating schedules that have to be completed within specific time frames. Notice the
structure of the example in Figure 2.2. The date value operates as text in quotes.
Common DATE AND
AVERAGE returns the average of the arguments.
The AVERAGE function averages the numbers over a range or in the form of an array over several
ranges. Figure 2.3 shows the AVERAGE function averaging the dollars from column E, “Total
Use COUNTA to count the number of cells that are not empty and the values within the list of
The COUNTA function illustrated in Figure 2.3 shows the count over the range of cells to equal 5.
Blank cells are not counted. (Use the COUNT function if you want to count blank cells as well.)
The COUNTIF function counts the number of cells within a range that meets the given criteria.
COUNTIF is used over a range of cells and returns a numeric result based on logical criteria. The
logical criteria in Figure 2.3 is in quotes, and counts all values in excess or greater than 10,000.