Microsoft Office Tutorials and References
In Depth Information
Using WORKDAY or NETWORKDAYS or Their International Equivalents to Calculate Workdays
You must format the result of the EDATE formula to be a date to see
the expected results.
months — This is the number of months before or after start_date. A
positive value for monthsyields a future date; a negative value
yields a past date. If monthsis not an integer, it is truncated. If
start_dateplus monthsyields an invalid date, EOMONTH returns a
=EOMONTH(A2,0) converts any date to the end of the month.
WORKDAY oor NETWORKDAYS
NETWORKDAYS oor Their
The functions WORKDAY and NETWORKDAYS are pretty cool. They calcu-
late days by excluding weekends and holidays. Weekends can be any two-day
period, such as Saturday/Sunday or Thursday/Friday, or any one day, such
as only Sunday.
These functions are great for calculating shipping days when you ship with
FedEx or UPS. They are great for making sure your result doesn ’ t fall on a
bank holiday. Here ’ s how you do it:
11. In an out-of-the-way section of a spreadsheet, enter any holidays
that will fall during the workweek. This might be federal holidays,
floating holidays, company holidays, and so on. The list of holidays
can either be entered down a column or across a row. In the top portion