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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude Weekends 4
Calculating days spent to complete a task 2
Date Calculation Formula- Calendar days minus Holidays 1
Calculate End Date (excluding weekends and holidays) 6
Date calculation 1
Date count to exclude weekends 0
Date Calculation problem 3
Generate Payment Due Date to exclude Weekends and Public Holiday 4

Top