Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

Use the NETWORKDAYS function to determine number of workdays
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

In this example a project has to be scheduled. Each of the five steps has a fixed start and end date. To determine the number of complete workdays between the start and end dates, the NETWORKDAYS function from the Analysis ToolPak add-in can be used. This function excludes weekends and any dates identified as non-workdays and holidays. The syntax is as follows:

NETWORKDAYS(start_date, end_date, holidays)
start_date: The start date.
end_date: The end date.
holidays: (optional) One or more dates that are to be excluded from the work schedule.

To determine the number of workdays:

  1. In column B type the start date of each step.
  2. In column C type the end date of each step.
  3. List additional holidays in cells F2:F6.
  4. Select cells D2:D6 and type the following formula: =NETWORKDAYS(B2,C2,$F$2:$F$6).
  5. Press Ctrl+Enter.

Use the NETWORKDAYS function to determine number of workdays

Use the NETWORKDAYS function to determine number of workdays
  1. How to use the WORKDAY function to calculate workdays in Excel
  2. How to Use the SUMSQ function to determine the square sum
  3. How to Use the STDEV function to determine the standard deviation
  4. How to Use the LCM function to determine the least common multiple
  5. How to use the GCD function to determine the greatest common divisor

Article Information

Category
Formula and Function Examples

Tags
, , ,

Trackback URI

Comments RSS


Leave a Reply

← How to Use the RATE function to calculate interest rate in Excel
How to add months to a date using the DATE Function in Excel →