Cross sheet Avg between dates / year / month

Jason P

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.

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.

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.