Calculate the number of days between dates (excluding weekends)

[bdav1216]

How do I subtract two dates, using the work week (excluding weekends and/or holidays (if possible)?

When either date is blank, default in N/A

Column A Column B Column C
Date 1 Date 2 Expected Result:
12/02/19 12/04/19 2
_______ ___________ N/A
11/21/19 11/25/19 2 (this example has a weekend). I am counting 11/2/19 as Day 0

[6StringJazzer]

Look up the NETWORKDAYS function, which is built-in and does everything you are asking for.

You will have to add a little wrapper for the N/A.

[bdav1216]

Yes, I have reviewed that formula and am seeing unexpected results:

=NETWORKDAYS(B2,A2)

When there are no dates, I need that to have an 'N/'A value to differentiate these. There are some situations where one date is present but the not other - I still want that to be a 'N/A'
One other adjustment. If the date is illogical - meaning the result of the calculation is a - (negative) date, output a N/A. This happens when Column B is more recent than Column Column A.

Column A Column B Column C
Date1: Date 2: Current Result:

________ _________ 0 (expecting this to be N/A)
3/16/2019 3/16/2019 0 (this is a weekend date - I agree with a result of '0')
4/16/2019 4/16/2019 1 (Why is this a value of '1'?)
12/5/2018 12/3/2018 3 (Expecting a value of '2').
10/7/2019 10/9/2019 -3 (illogical - can this defaulted to N/A?)

[6StringJazzer]

Please Login or Register  to view this content.

4/16/2019 4/16/2019 1 (Why is this a value of '1'?)

Because if you start something on 4/16 and finish on 4/16 it took you one day (not zero days). For your purposes you may need to subtract 1 from your result.

You also need to set up a list of holidays and add the third argument.