Microsoft Office Tutorials and References
In Depth Information
Syntax
Figure 11.47.
Figure 11.47. WORKDAY
can calculate the number of
Monday-through-Friday days, exclusive of a range of holidays.
WORKDAY and
and NETWORKDAY
NETWORKDAY can calculate the number of
Monday-through-Friday days, exclusive of a range of holidays.
22. Enter a starting date in a cell, such as B1.
33. In another cell, enter the number of workdays that the project is ex-
pected to take, such as B2.
44. Enter the ending date formula as =WORKDAY(B1,B2,E2:E7)
=WORKDAY(B1,B2,E2:E7).
The NETWORKDAYS function takes two dates and figures out the number of
workdays between them. For example, you might have a project that is due on
June 17, 2015. If today is April 14, 2015, NETWORKDAYS can calculate the
number of workdays until the project is due.
Syntax
=WORKDAY(start_date,days,holidays)
Syntax
=NETWORKDAYS(start_date,end_date,holidays)
Search JabSto ::




Custom Search