Cross sheet Avg between dates / year / month


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?



Forever forwards Backwards never.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!