Date Calculation to exclude weekends

V

Vim

Pls Help!

I'm trying to subtract a delivery date with order received date and it shows
a value...fine....but how do get the formula to ignore weekends to show a
true working working and more accurate number of delivery days.
 
D

daddylonglegs

If you have Analysis ToolPak installed you can use NETWORKDAYS, e.g.

=NETWORKDAYS(A1,B1) where your first date is in A1 and second date in
B1
 
Top