Networkdays formula not behaving as expected
Hi I'm having an issue with NETWORKDAYS not behaving as expected, I'm trying to report project timeline variances between baseline and actual. I have defined working days and holidays but the results are not as expected, any thoughts?
- I'm using this formula in the Project Start var. column a =NETWORKDAYS([Actual Start Date]4, [Baseline Start Date]4)
- and this formula in the Project End var. =NETWORKDAYS([Actual End Date]4, [Baseline End Date]4)
- January the 1st is set as a holiday in the template settings and weekends are non working days. Line 3 looks right but line 4 is adding a day tot he total for each column
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.