Average formula with weekends excluded

Options
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!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!