The followiing IF/AND formula should do the task for you:-
As I don't know how your work book is set up, have a look at my test work book at the following link:-
You'll see that I have the Declaration Start Date in cell A2 and the other data in the range A4:C. The formula is in Column C. Change the cell references in the formula to suit your work book. Drag the formula down as far as you need.
In the test work book, change/mix the dates and inventory criteria to see the formula at work.
I hope that this helps,