Sales Report that looks @ Start dates and Expired dates

[pmw19800]

Hello all

Please attached to help understanding

On the SALES tab this is currently summing sales for the month..

PRICES Tab – these are the prices for the parts on SALES tab, some prices have an expired date and new price will be on the list somewhere

I need a formula that looks at PRICES tab and checks what price it needs to multiplied by, so it reports the sales in terms of money,
It will look at the expired Column and see the expired date and know I can’t use that price this month I need to find the new price


thanks for your time

[bebo021999]

You did not tell us where is your expected outcome. Pls manualy type in few rows of desired result.

[pmw19800]

On the Sales Tab - I need that look up the data from the raw tab and report what’s been shipped, and then the sum of that calculation is to be x by the price on the PRICE list, whilst looking at the expiry dates