Changing date within formula


I am looking to find a way to incorporate a changing value to the hours needed per day in order to meet deadlines. In addition i've input task completion % in order to account for the completion rate. My current formula is the following :

=IF(ISNUMBER([Man Hours Allowed]3), ([Man Hours Allowed]3 / Duration3) * (1 - [% Complete]3), 0)

I'm assuming something along the lines of "End Date - Today" would help, but am unsure how to incorporate in place of the "Duration" value

I've provided a screenshot of a partial template in order to better represent the question



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!