To map old Code to New Code base on Date

[FT00]

Hi, i have to tag my old code to new code base on Date Criteria and then do a Sumif base on Date and the Old Code/New Code.

However, i seems to be stuck. Cant think of a way to do this. In my sample, I would like to return Yellow Colour portion.

Can anyone think of any formula to do?