Variance Between 2 Dates (Weekdays Only)

Paul Newcome

It looks like a misplaced parenthesis.

=IFERROR(NETWORKDAYS([Finish Date (Actual)]12 - [Finish Date (Plan)]12), "")

Anthony Barthelemy

Still Incorrect Argument Set

Paul Newcome

Duh. Sorry. It's been a long day. No subtraction. Just a comma...

=IFERROR(NETWORKDAYS([Finish Date (Actual)]12, [Finish Date (Plan)]12), "")

If that is providing results on the wrong side of zero, switch the dates around so the plan is before the actual.

Anthony Barthelemy

That worked but I made an adjustments of +1 and that resulted in -1 (a day early). However, the Plan Finish Date and Actual Date were Identical.

I am thinking my +1 is in the place?

=IFERROR(NETWORKDAYS([Finish Date (Plan)]12 + 1, [Finish Date (Actual)]12), "")

Paul Newcome

If both dates are the same, it should have given you a 1. Since you are starting and finishing on the same day, you are taking up 1 day. That's why if it seems like the dates are only one day apart (today and tomorrow), you would get a two.

Does that make sense/help any?

Anthony Barthelemy

Yes, Thanks

Paul Newcome

Excellent. Happy to help! 👍️