Ignoring weekends in days calculation

Hi all, I'm attempting to find a formula that allows me to ignore weekends to get an accurate count of how long an assignment is taking. A screenshot of what I'm looking for is below.

I want to take the Date PIC Received - Date PM Assigned and ignore weekends. So in the below example, it should be 1 day since the 23rd was a Friday, and the Assignment was made on Monday.


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!