Calculate days between two dates w/o weekends

GK2019
GK2019
edited 12/09/19 in Formulas and Functions

Hello all,

I need to calculate the number of days between two dates (neither of which will be today), without including weekends. Does anyone know how to do this? Examples are listed below

EX: 09/09/2019 - 09/08/2019 = 1

EX:  09/16/2019 - 09/13/2019 = 1

Any help would be much appreciated! Many kind thanks!

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!