Calculating a date using a 'date' column and a 'number of days' column
Victoria Ganuelas
✭✭✭✭
I need a formula that takes a 'date' column and minus' the number in a 'number of days' column to show that calculated date in another date column.
Answers
-
Hello @Victoria Ganuelas
This should work:
=WORKDAY([Original Date]@row, -[Number of Days]@row)
Make sure the column type with the formula is set to Date.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!