If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how I exclude weekend dates
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 |
#2
|
|||
|
|||
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 | |
Display Modes | |
|
|