Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Date formula

jovan12971
✭✭
Hi
I'm working a construction project, and need to use a formula (or another method). To have a cell generate a remainder duartion period, based on a set completion date and duration against the current date.
I look forward to any suggestions.
Thanks
Comments
-
Assuming your end date is in a column called "Date" in row 1...
Formula:
=Today()-[Date]1
This discussion has been closed.