Formula to calculate time between today and a date in the future.
I need to calculate the work days between my "Requested Customer Date" and today, minus two days. This is the formula I currently have, but it's not calculating correctly.
=NETWORKDAYS([Requested Customer Due Date]@row, TODAY()) - 2
Answers
-
Can you provide some example dates and outcomes of how it is currently working?
-
I have the formula in the Project Timeline column
-
They look correct to me. What would be the expected results?
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!