Calculating Differece Between Dates

Hi,

I need your help in creating a formula or a macro which would help me get the difference between two dates whe7rein weekends are not included in the count such as the following:

Planned date: March 9, 2016
Actual date: March 9, 2016
Difference: 0 day

Planned date: March 9, 2016
Actual date: March 8, 2016
Difference: -1 day

Planned date: March 9,2016
Actual date: March 10, 2016
Difference: 1 day

I tried using formula for networkdays but Im not getting the desired results. For first example above, it states 1 instead of 0. Is there a way to formulate this? Appreciate your help on this.

JV

Assuming your Planned Date is A2 and your Actual Date is A3, then try this:


Cheers,

Thank you! This actually solves my issue