The Solution 1 given by
Fredrik Bornander is very good.
I want to add that, as observed from the pattern of values in columns A, C, the total of
A+C
is
2013, 2012, 2011
under each part in the consecutive three rows, except for row 3 in Part 2 and row 2 in Part 5. I think by following the pattern there may be a typing error in these rows.
If that is the case then the correct values could be 2009 in row3 of Part 2 and 2007 in row 2 of Part 5 in Column A
and the following expression can also be used.
=IF( AND(A2 <= 2012, A2 >= 2006, C2 >= 1, C2 <= 5),1-(A2+C2-2013),0)