how I exclude weekend dates

E

Edward Chenderes

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
How to automate update on weekly reports spreadsheet 0
2016 Project, adding a workday to custom field 0
Count days between two dates excluding weekends 2
Calculating days spent to complete a task 2
Countdown macro - display settings 2
calculate number of days formula 11
Date Formats 4

Top