Need to Find a Number between dates

First off, thank you in advance for any assistance with this question. I don't even know if this is possible (knowing this group though, there is always an answer).

I have attached a sample spreadsheet with the values entered in the column I need the formula in (expected results). The workbook has two tabs. The first one has the source data and the second tab is where I need to have data entered.

I need to pull (in this example) the number of bread loaves baked between two dates. If the date I am looking for isn't in the source then the number of loaves I need is under the first date before the one I am looking at. I hope that isn't too confusing.

Thank you again!

Cliff Watson

Give this a try

=LOOKUP(A7,Breads!$D$1:$T$1,INDEX(Breads!$D$2:$T$8,MATCH($B$1,Breads!$A$2:$A$8,0),0))

That is perfect! Thank you. I had to alter it a little because the dates that are copied in are text (they have to be converted to a date) and there are columns with no data.

Thank you very much!!!!!

Formula:

Please Login or Register  to view this content.

Sorry JonMo1 - I tried to add to your rep but it said I had to spread some rep around before I could.

You're welcome.

You might be better off in the long run actually converting the text dates to real dates.
I used Data - Text to Columns - Fixed width.
And put a delimiter after the first comma (basically removing the weekday mon tue etc.)

It would be fewer calculations (about 30 per tab, 64 tabs... okay so it isn't about bread ) but that would mean I would have to do that for all 64 tabs every time I paste in new data.

I did say ‘might be’

Unfortunately, I don't have control of the data. It's given to me as text and there are 64 sets of data with about 30-35 lines of data per set (each line of data occurs on a different date). I will use the text/column trick on a few sets of data and see how much longer it takes me.