Firstly, apologies for this question but I couldn't really wrap my head on how to do this (ultimate aim is to put it in app scripts)
Let's say I have a table that is updated daily showing the fruit Tony eats on that day
For some reason, I need to find the number of days between eating Pear followed by Apple. Here it is manually done by subtracting the dates
How would I translate this into a formula? I tried reading up on VLOOKUP, INDEX,SMALL, XLOOKUP but didn't get a hang of the approach
I am aware the on SE, one needs to show what has been done by OP to solve but in this case, I am totally confused, sorry again.