IF text string is equal left characters and DDMM of DOB is outside a range.

Hi,

I have a multiple vlookup I'm trying to accomplish and I'd appreciate some help.

Basically I have I need the formula to check the following.

Firstly using IF/Left does the start of a text string have the characters ABC for the first 3, if so then VLOOKUP cell B1 to determine if the persons DDMM of their birth is in the 3 days after the last day of the end of the period in cell B1 (held in a named range called paycals)

I've started the formula but I don't know how to tackle the 3 days part.

=IFERROR(LEFT(C3,3)="ABC",AND(VLOOKUP(E1,PayCals2,false)=

Would anybody have anything similiar? I've attached an example file.

Thanks