Microsoft Office Tutorials and References
In Depth Information
Perform
DATE CALCULATIONS
One special-purpose Date and Time function enables
you to find the number of workdays between two
dates. Like other Excel functions, Date and Time
functions make use of the Function Wizard. As with
all functions, the wizard works with data you type
into the wizard, such as a specific date, and with
data you have typed into cells in your worksheet.
To calculate the number of workdays between two
dates, you use the NETWORKDAY function. The
function’s arguments include a start date, an end
date, and optionally, any intervening holidays that
automatically reduce the number of workdays
between the two dates. Excel automatically deducts
the number of weekend dates.
Excel can perform date arithmetic on any date after
January 1, 1900. If you use dates before then,
Excel treats them as text and does not perform
a calculation on them. Instead, it gives you a
#VALUE! error.
F IND N UMBER OF D AY S B ETWEEN
T WO D ATES
1
4
Type the start date.
2
Type the end date.
If you want the calculation to
consider holidays, type the dates
of holidays between the start
and end dates.
l
1
2
3
3
Click the field in which you want
the result to appear.
4
Click the Insert Function button.
l The Insert Function dialog box
appears.
5
Click here and select Date &
Time.
6
Double-click NETWORKDAYS .
5
6
50
 
Search JabSto ::




Custom Search