Comparing a complete set of dates with an incomple...

[meprevost024]

Hi everyone! 

I'm trying to create an automation that tracks data from two columns. We have a "planned publish date" and an "actual publish date." I'd like to have a way to track how frequently records are published within a week or so of the planned publish date. 

Is there a way to set up reporting in an interface for this? Or an automation that can compare the two dates and perform an action if they're within a certain timeframe to one another? 

I haven't tried writing my own script, but I'm open to that, as well as other suggestions. Thanks so much!