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

Options

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:

=((B2-A2)/A2)*100

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

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


Help please :)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!