Adding BankHolidays while disabling dependencies

edited 12/09/19 in Smartsheet Basics

Hello SmartSheet community,


I would like to add bankholidays under a "depencies disabled" mode.

It this possible ?


I take it that with a "dependency enabled" mode, that's already feasible.





  • Alejandra
    Alejandra Employee


    At this time, dependancies must be enabled in order for non-working days or holidays to be excluded in the duration calculation.

    As a workaround, you could create a formula using the NETWORKDAY function to calculate the number of days between two dates, adding 1 day to the result if the start date is a non-working day.

    The NETWORKDAY function allows you to enter the dates you would like to exclude. More information on this function can be found here: