date analysis

[Faisalomran1]

in the table above each ( Well Api Number ) has Two or more ( Job Start Date) with different period of time between first and second (Job Start Date). what I am trying to do is to create a new table that has the ( Well API Number ) with more than one (Job Start Date) with in a period of at-least 3 months between the job start dates.

your help would be really appreciated.

thank you

[morr-co]

Hello @Faisalomran1 - I believe this will give you the results you are looking for. The solution is also dynamic should you have more than two start dates for a well api number.

[TheOC · Accepted solution]

(copied post from your other post)

hi @Faisalomran1 

here is a workflow that achieves this!

Formula calculated the difference, and a filter applied on the months between gets the ones that are 3 month or more

If this helps, please accept as a solution to help others find the solution 🙂