formula for calculating between dates


I am looking for a simple formula to count the difference between 2 dates in number of days.

Where 'Finish' is the completion date of project, and 'TODAY' is today's date, and the formula needs to calculate the difference between the two.

I have tired to use the following formula but it just returns #DATE EXPECTED:


I also tried this formula with the same result:

=NETDAYS(Finish@row, TODAY@row)

be glad of any help! 😉

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!