Use of WORKDAYS or NETWORKDAYS to return weekday date on a calculated date field

I have two kinds of calculated date fields in columns that work, but I need them to only return weekdays/workdays.

Is it possible to use WORKDAYS or NETWORKDAYS on a calculated field to only return weekdays or workdays?

Here are the date field examples:

.....PlannedEnd2 equals PlannedStart2 plus 5 days......

     =[PlannedStart2]@row + 5

.....PlannedStart2 = One day after ActualEnd1 or PlannedEnd1 if ActualEnd 1 is blank.......

    =IF(ISBLANK([ActualEnd1]@row), [PlannedEnd1]@row + 1, [ActualEnd1]@row + 1)

So if the result of either of the above is a Saturday, how can I get the formula to return Monday's date? Thank you in advance.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!