Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Using Calendar Days but, not including weekends or holidays for my end dates.

Jerry Tutt
Jerry Tutt ✭✭
edited 12/09/19 in Archived 2016 Posts

I believe that I may have asked this in the past but, in the legal profession we use calendar days for calculating dates but, do not want the completion dates for most tasks to fall on a weekend or holiday.  Any solution to this?  I came up with some fancy formulas to do this but, because Smartsheet uses its calculated date and not my adjusted dates my dates come out incorrect.  I still use my formulas to verify the dates and adjust the durations accordingly and hide my working column.  Any suggestions?  





This discussion has been closed.