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:

=((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 :)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide screenshots?

Darius CDD

@Paul Newcome Here is a screenshot of my actions:

Paul Newcome

So basically you want to take the original duration and calculate the variation based on the new duration? Are they both using the same start date?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.