Networkdays formula for a year and a month


I am trying to work on the above for my Sales Team.

Let's say the target sales is $1,000,000 for the year, and they have achieved $104,000.

For the remaining target of $896,000, I would like to show the remaining target for this month by dividing $896,000 with remaining working day this year, multiply by remaining working day this month.

Which means "This month remaining target" will fluctuate depending on the sales performance. If it is not achieved, then next month will have higher target to achieve.

Appreciate any help on this.

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!