Count days without weekends
 

Hello is there any day that I can count days between two dates without
including weekends? Please see below an example:
Date1 Date2 # of business days
3/19/08 3/24/08 3
3/20/08 3/24/08 2
3/21/08 3/24/08 1
3/24/08 3/24/08 0
3/24/08 3/25/08 1

Count days without weekends
 

See NETWORKDAYS in Help.

Compare Values wrote:

Hello is there any day that I can count days between two dates without
including weekends? Please see below an example:
Date1 Date2 # of business days
3/19/08 3/24/08 3
3/20/08 3/24/08 2
3/21/08 3/24/08 1
3/24/08 3/24/08 0
3/24/08 3/25/08 1

Count days without weekends
 

See NETWORKDAYS function in Help.

Enter =NETWORKDAYS(A1,B1) in C1 and copy down.

Note: the function counts both start and end date so your 3 will be 4 etc.

Note: the ATP must be loaded.


Gord Dibben MS Excel MVP

On Mon, 7 Apr 2008 13:02:01 -0700, Compare Values
wrote:

Hello is there any day that I can count days between two dates without
including weekends? Please see below an example:
Date1 Date2 # of business days
3/19/08 3/24/08 3
3/20/08 3/24/08 2
3/21/08 3/24/08 1
3/24/08 3/24/08 0
3/24/08 3/25/08 1