Date formula that excludes Saturday & Sunday

Lazar.A

Currently I have a formula that calculates project due date - 3 days =[Bid Due Date]@row -3

What formula can I use to exclude Saturday & Sunday ?

AnthroTim

Hi,

You can use the NETWORKDAYS function to calculate the number of working days between 2 dates. this will exclude weekends (Sat & Sun)

See this reference for more details:

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

It also lists some of the related formulas that may be handy.

Tim

anthrotechnic.com