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

Jerry Tutt

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?  

 

Thanks, 

jerry

Jeff K.

Try using NetworkDays() or WorkingDays()

 

 

Heidi Decker

Hi Jerry,

Try using elaspe time on those tasks you don't want to finish on a weekend or Holiday.

Here is a thread on it.

https://community.smartsheet.com/discussion/work-days-not-normally-work-day

Peace

Jerry Tutt

Thank you so much... I will definately check this out.  

 

jerry