Forumla to calculate the percentage (%) change between two dates


Here, I am seeking to capture the % change between original finish date vs actual finish date.

Example dates are as such:

Original Finish Date = 3/1/23

Actual Finish Date = 4/15/23

What is the percentage change in the date difference? I would like to calculate this to speak to owners of task saying "hey, you deviate from original completion dates by __ % & overall on average __% of the time."

I have attempted to utilized the follow to try calculating the % change between dates but have had no luck as example:


& =IFERROR(((DATEVALUE(B2)-DATEVALUE(A2))/DATEVALUE(A2))*100,"Invalid Date Format")

Smartsheet continues to give me an invalid return OR #UNPARSABLE return.

Help please :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!