PLEASE HELP! formula to calculate % of completeness between two dates

Options

Hi All!

I am looking for help with a formula to calculate % of completeness between two dates in my sheet. After inputting the formula, I am getting the #INVALIDDATATYPE. I have checked that all of my columns are date-assigned. Can someone please help me? Here is the formula that I am using with a screenshot of my sheet.

Thanks in Advance!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!