Average formula with weekends excluded

Lachlan Stead

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!

Lauren B

How are you calculating the Time Taken to Complete column values? If you are getting them from subtracting a Start Date from an End Date, then you can use the NETWORKDAYS function instead:

=NETWORKDAYS([Start Date]1, [End Date]1)

Then your formula above should work as is.

Lachlan Stead

Thanks Lauren, that's perfect!