Max If formula - where am I going wrong

[Pumperkin]

Hi, Not sure where I've gone wrong and this should be a fairly simple one hopefully.

I have dates despatched in one column and time in stock in another. I wish to make a graph to show (hopefully) a quicker stock turnover as time goes by.

I have the following, where Sheet1!A contains dates, Shipped!K is date despatched and Shipped!M is time in stock.

=MAX(IF(Shipped!K:K < Sheet1!A2, Shipped!M:M))<sheet1!a2, shipped!m:m)[="" code]<sheet1!a2,="" shipped!m:m))[="" code]
<sheet1!a2, shipped!m1:m1000))[="" code]

As always, help gratefully received. I am entering as Array </sheet1!a2,></sheet1!a2,>

 

[AhoyNC]

Probably need to clarify what you mean by gone wrong.
Are you getting an error msg., wrong answer?

 

[Pumperkin]

Probably need to clarify what you mean by gone wrong.
Are you getting an error msg., wrong answer?

Hi AhoyNC, thanks for your reply.

I am just getting a list of blank values, rather than the max value. If I change the sign to > , it gives them after this date, but when it is < it doesn't give any values.

I think it may be more complicated than just pulling the data, as a device that was 1 day old on 2nd August will be 2 days old on the 3rd. My data just shows the days it took in total to send out the device, so on 2nd August it would show 2 days instead of 1.

Hmmmmmm

 

[Pumperkin]

The way I see it, I almost need a Z axis on the spreadsheet.

I am looking for a list of all devices, listed against a date sent, then a date diff between my list of dates and sent date, then the maximum value of this list, not forgetting that if it has been sent it is then no longer in stock. Argh....