Getting difference in dates based on specific case numbers

Hey all,

See attached for example. I redacted names and sensitive info obviously.

What I need to do is figure out when a case (Column A) was "Created." and when the "Case Owner" field was updated. Some cases don't have an update to the "Case Owner", so I don't need to worry about those, but some cases also have multiple Case Owner updates. All I need is to find the number of days from when the case was "Created." to the first "Case Owner" update for that case. This sheet has around 11k rows

Let me know if you need more info. I'm not too great at explaining myself but I can't figure out how to find the days between dates on a case by case basis

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. If there is sensitive data then anonymise it. Pictures are rarely much use when we need to test solutions.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Let me know if you need more info.

Yes … Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

Thanks for the rep. Though, clearly, the hard work was not done by me ... Thanks anyway