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