Average turnaround time in 45 day period

Hi all,

I am trying to calculate the average turn around time in a sheet summary (=ROUND(AVG([Turnaround Time]:[Turnaround Time]))) for the past 45 days (not all time, like it is currently). I tried adding <=TODAY (-45), but that did not return an accurate count. I feel like I'm missing something simple!

Turnaround time is calculated in the sheet as: =IF(ISBLANK([Date Lab Results RCVD]), "", NETDAYS([Date Lab Rcvd], [Date Lab Results RCVD]))

Find more posts tagged with

Accepted answers

Ramzi K

@Megan T

Try this formula:

=ROUND(AVG(COLLECT([Turnaround Time]:[Turnaround Time], [Date Lab Results RCVD]:[Date Lab Results RCVD], <(TODAY() + 45))))

This assumes that the reference date you want to use is [Date Lab Results RCVD]

I hope this helps,

Cheers,

Ramzi

All comments

Ramzi K

@Megan T

Try this formula:

=ROUND(AVG(COLLECT([Turnaround Time]:[Turnaround Time], [Date Lab Results RCVD]:[Date Lab Results RCVD], <(TODAY() + 45))))

This assumes that the reference date you want to use is [Date Lab Results RCVD]

I hope this helps,

Cheers,

Ramzi

Megan T

Like a charm! THANK YOU!

Megan T

@Ramzi K

I noticed this wasn't counting back, but forward. This formula worked for 45 days:

=ROUND(AVG(COLLECT([Turnaround Time]:[Turnaround Time], [Date Lab Results RCVD]:[Date Lab Results RCVD], >=(TODAY() - 45))))

And this one for two weeks:

=ROUND(AVG(COLLECT([Turnaround Time]:[Turnaround Time], [Date Lab Results RCVD]:[Date Lab Results RCVD], >=(TODAY() - 14))))

Thanks again for the assist!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.