Formula to count days past a certain date without weekends

AGE_UT

Hi!

I have a sheet where one column has a submission/end date ("END DATE: CA Exam 4 Part 2") and another column is a "due by" date ("E4 Window Closes"). I have a column that I keep hidden which has that "due by" date ("E4 window closes") to help in the formula I have running:

=IF(AND(ISDATE([E4 window closes]@row), [E4 window closes]@row <= TODAY()), MAX(0, IF([END DATE: CA Exam 4 Part 2]@row <> "", [END DATE: CA Exam 4 Part 2]@row, TODAY()) - [E4 window closes]@row))

This is pretty good because it is correctly counting the days after the deadline ("E4 Window Closes"), but how can I edit it to where it will NOT count the weekends? (Ex. Exam 4 end date is scheduled for 1/21/25, but the "E4 Window Closes" [deadline] is 1/17/25. I want the formula to give me 2, not 4).

Thank you!

Paul Newcome

I would suggest the NETWORKDAY function:

https://help.smartsheet.com/function/networkday

.