Hello!

I am stuck with this problem for quite some time now and I really need help. 

I have this pivot table that has the product on the rows and the shipment dates on the column and the quantity in the shipment as values.

Basically, what I want to create is a formula that will get the next shipment date for each product. If the date is past then it should tell me the next date. Or there is a better way of doing this, please do share. Thank you!

​Hello!I am stuck with this problem for quite some time now and I really need help. I have this pivot table that has the product on the rows and the shipment dates on the column and the quantity in the shipment as values. Basically, what I want to create is a formula that will get the next shipment date for each product. If the date is past then it should tell me the next date. Or there is a better way of doing this, please do share. Thank you!   Read More

​