Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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,

Comments

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