Excel 2019 Spreadsheet date formula help

I have a large spread sheets with horse, races, dates etc. I would like to create a formula that can calculate the days between each run. So for example if I put a horsesname in a search box it will give me the days beween past runs

This is a condensed version
Many Thanks

Basically I would like to compile another Table that when I enter a Horsename it will search Column N then reference Column A to see the length of time between each of its runs

So you just want to use an Index Match () formula like i put below. This is saying your horses name you are looking up is in Cell B1. Change it to whatever you want.

=INDEX('TOTAL 2'!A:A,MATCH(B1,'TOTAL 2'!N:N,0))

this formula returns the date in column A. You could then add simple logic like TODAY() to the beginning and it will take todays date less the date returned from the lookup and give you amount of days inbetween. Formula is as follows:

=today()-INDEX('TOTAL 2'!A:A,MATCH(B1,'TOTAL 2'!N:N,0))

Just make sure the cell you have this formula in its number format is set to GENERAL so it shoes the amount of days and not some wacky date.

Thank you so much I will try this.
Much Appreciated

That worked perfectly to give me the days since the horses last run, is there a way I could continue it down the table so I could add a column for days between each previous run.
Many Thanks

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

Apologies I was replying to a post to my earlier thread of which I had a title

I have that uploaded Pete. It works great for the last run, I was wondering could I incorporate another column to show all previous days between runs ie last to second last, second last to third last etc.
Kind Regards

Please change your title as requested (post#8) and change your profile (post#9). Thank you

Is that ok now, I could not find where to update Excel Version only the windows version

Seems that you found it. Thanks

Morning Roel
Thank you very much for that it has given me another great tool unfortunately for what I am looking for i would need a column on my existing spreadsheet so I can lookup those days between races. I can so it with multiple index (sum) but as some of the horses have 20 to 30 runs it becomes very space consuming. I use a search pace so that when I enter several horse names I receive several columns of data. Speeds, Ratings etc I was looking to add how often that horse runs. So I enter horses names in column A and the work book looks up the previous example then fills in the columns with multiple min/maxif formulas. I wanted to add a days between runs to this workbook.