Determine # days from 1 date range to today
Options
JFrye
✭
Looking to assign a % complete to a project based on days from open to estimated close. Have a column showing total network days from these dates and now want to either nest a function to subtract the overall days from the current days (open to estimated close minus open to today). I am new to Smartsheet so am having a problem getting the "today" part set up correctly, Any input is appreciated.
Comments
-
=today()
Will return the current date. The parenthesis are needed after today in every case.
=today(1)
Will return tomorrow
=today(-1)
will return yesterday
https://help.smartsheet.com/function/today
-
Try...
=NETWORKDAYS([Date Opened]1, TODAY())
-
Thank you!!!
-
Thank you!!
-
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!