today plus x networkingdays

BlairMyles

how do i build a formula that gives me the actual date for today + 35 working days?

Mike Wilday

=Workday(Today(), 39) 

will give you 39 working days from today. 

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

You need to put that in a date column and you need to understand that the date will change each day you load the sheeet. Today() will always refresh with the current day's date. 

Hope that helps! 

BlairMyles

awesome thanks

Mike Wilday

You're welcome!