Count days without weekends

[Compare Values]

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

 

[Bob I]

See NETWORKDAYS in Help.

 

[Gord Dibben]

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