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:
be glad of any help! 😉
Help Article Resources
Check out the Formula Handbook template!