Determine # days from 1 date range to today

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.

L_123

=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

 

Paul Newcome

Try...

 

=NETWORKDAYS([Date Opened]1, TODAY())

JFrye

Thank you!!!

JFrye

Thank you!!

Paul Newcome

Happy to help.