Calculate days between two dates w/o weekends

GK2019

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!

 

alex44

One of these two options should get you what you need:

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

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

GK2019

Thanks alex44! Worked like a charm!