Variance Netdays

Philippe Honore

Hello everyone,

I read some of the threads about this issue, but cannot find the right answer.

Members of my team are consultants and work primarily on weekends so I am using the NETDAY function to calculate the variance. If I use the formula as is, meeting the deadline will give a "1" instead of 0. To avoid this I added a "-1" at the end of the formula to have a "0" variance when the submission date meets the deadline. Although we someone submitted a day in advance (a Tuesday instead of a Wednesday) the variance shows "-3" instead of "-1"

Help!

The function:

=IF([Actual Date of Submission]12 <> "", NETDAYS([Due Date]12, [Actual Date of Submission]12) - 1, "") 

Paul Newcome

Try skipping the NETDAYS function.

 

 

=IF([Actual Date of Submission]12 <> "", [Actual Date of Submission]@row - [Due Date]@row, "")