Average formula with weekends excluded

Lachlan Stead
Lachlan Stead ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello All,

I need to tweak a very simple formula. Currently i have this '="Average Resolution Time - " + AVG([Time Taken to Complete]33:[Time Taken to Complete]148) + " Days" ' but i really need something that only averages workdays within that time period. Be very glad i any suggestions. I started experimenting with the =workday formula but haven't been successful as yet!

Thanks for you assistance in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!