Formula for populating a due date

LPeyton

I am trying to set a formula to automatically populate the due date using workdays only and excluding holidays. I have a beginning date and would like the end date to be the formulated due date. I am stumped on this formula! Anyone suggestions are appreciated.

Dale Murphy

@LPeyton Why not let SmartSheet do that for you? Date management is at the heart of the project management functionality.

dm

Genevieve P.

Hi @LPeyton

Do you have a Duration column in your sheet where you identify how many working days you want to add to the Start Date to create the Due Date?

If so, you can use the WORKDAY formula, like so:

=WORKDAY([Start Date]@row, Duration@row)

Then to exclude holidays, you can have a date column in your sheet that identifies all the dates that should be skipped and you can reference that at the end of the formula.

See: https://help.smartsheet.com/function/workday

Cheers,

Genevieve