Nested IF/OR formula or vba code instead?

Hello and thanks for reading :-)
I have a spreadsheet which contains dates (amongst other info) of when a specific form was completed for a client. We have 'date windows' which these should fall into. I'm really struggling with how to work this one out and whether to use nested IF's or try some kind of code (although my vb knowledge kind of stops after recording a macro lol)
Bascially I need to know for each 'date window' if the window has been met or missed. There may be up to 30 different dates per person (in my example sheet I have up to 9) and I was wondering if anyone can give me pointers on how to do this without it taking forever!
Thanks
Rachael