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

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
>
>

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
<(E-Mail Removed)> 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
>