Microsoft Office Tutorials and References
In Depth Information
l The Function
Arguments dialog
box appears.
7
Click in the cell
containing the start
date or type the cell
address.
8
Click in the cell
containing the end
date or type the cell
address.
l Optionally, click and
drag the range of
holidays or type the
range.
7
8
9
9
Click OK.
The cell with the formula displays the net
workdays between the two dates.
l
Did You Know?
In Excel you can enter the current
date simply by clicking in the cell
in which you want the date to
appear and pressing the Ctrl and
semicolon keys at the same time.
Did You Know?
There are more than 15 ways you
can format a date, including
August 1, 1956; Aug 1, 1956;
01-Aug-56, Wednesday, August,
1956, 8/1; and 8/1/56.
Did You Know?
When calculating NETWORKDAYS ,
if your start date is later than your
end date, Excel returns a negative
number.
Chapter 2: Work with Formulas and Functions
51
 
Search JabSto ::




Custom Search