Forum Discussion

killwa16's avatar
killwa16
Copper Contributor
Jul 26, 2024

Formula to look at the dates given a condition

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!

 

Resources