| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
how I exclude weekend dates
NETWORKDAYS Function help.
Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. What "doesn't work"? Gord Dibben MS Excel MVP On Tue, 24 Oct 2006 05:44:02 -0700, Edward Chenderes <Edward wrote: Hi, I am trying to work out a formula to exclude week end dates when it calculates the work days. I tryed to instal the add inn but it does'nt work. Pls help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use conditional formatting to hilite weekend dates where. | Excel Worksheet Functions | |||
| Removing Weekend dates from Day Calculations | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Shading row with weekend dates | Excel Discussion (Misc queries) | |||
| I need to exclude duplicate patient names for dates of service is. | Excel Discussion (Misc queries) | |||
Threaded Mode
