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.

Cheers.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!