Work days formula

sahilhq ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


Is there any way you can advise of a formula where I can set something up that picks a date in a column and I set a specified number of working days which yields the final date.

So if I have a cell with a date of 10/09/19 and the working days I want to set is 14, what would the formula be like? 

I have tried using the workdays formula but it gives me an invalid arguement. Maybe I am not inserting the format of the date correctly? The attached picture shows what I am trying to do. I am looking for a result of 23/09/19. This is 14 days from the specified set date. 





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!