Track the number of days each task has been delayed

Blessing Ugbo

I am trying to track the number of days each task on my project plan has been delayed, I found a formula on https://www.smartsheet.com/blog/smartsheet-tips-tracking-baseline-schedule-variance

But the formula is counting weekend days (I already set work days to Mon-Fri). Any suggestions? 

 

Thanks,

SmSulli

I think you want to use the function NETWORKDAY

It gives you the number of work days between 2 dates.

This would be plan vs actual dates

=NETWORKDAY([Planned Finish]1, [Actual Finish]1)

Or you could compare Plan vs Today

=NETWORKDAY([Planned Finish]1, TODAY())

Shawn