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

TheOC

(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 🙂

Faisalomran1.yxmd