Counting only weekdays Formula?



I have a ticket tracker where it counts how many days a ticket has been open. Currently it includes weekends and i don't need it to. Is there a way or formula to count the amount of days a ticket has been open excluding weekends? I have a date created column and then a date closed column and use this formula current to capture the amount of days it has been open. Also while I need it to count the amount of days its been open i need it to stop counting if the date closed is there.

Formula; =IF(Status@row = "Closed", [Date Closed]@row - [Date Opened]@row, TODAY() - [Date Opened]@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!