Cross sheet Avg between dates / year / month

Hi,

Trying to ascertain the average shipping time on containers within a month / year by counting number of days between two dates from another sheets columns. Have tried a few combinations thanks to previous posts but all result in different errors.

=NETWORKDAYS(AND(IF({Container COMPLETED Range 7}, {Container COMPLETED Range 8},(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1)))

Started thinking no possible in one formula?

Cheers.

Find more posts tagged with

Accepted answers

Paul Newcome

You are going to need to calculate the number of days between the dates on a row by row basis on the source sheet. Then you can use cross sheet references to average them.

All comments

Bassam Khalil

Hi @Jason P

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Paul Newcome

You are going to need to calculate the number of days between the dates on a row by row basis on the source sheet. Then you can use cross sheet references to average them.

Jason P

Cheers.

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.