Variance Between 2 Dates (Weekdays Only)
Answers
-
It looks like a misplaced parenthesis.
=IFERROR(NETWORKDAYS([Finish Date (Actual)]12 - [Finish Date (Plan)]12), "")
-
Still Incorrect Argument Set
-
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.
-
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), "")
-
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?
-
Yes, Thanks
-
Excellent. Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!