Nested IF/OR formula or vba code instead?

[rachbendy]

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

[Special-K]

You can shorten that formula in C2 by replacing it with

=IF(ABS(B2-A2)>14,A2,B2)

Try using VLOOKUP. In another part of the sheet (or on a separate sheet) enter this as a vertical table, I've chosen C14:D20

Please Login or Register  to view this content.

Then this formula

=VLOOKUP(INT((D2-C2)/7),C14:D20,2,TRUE)

will provide you with the window the date sits in

Also in your formulae in row 2 you dont have "Missed Window 1" anywhere

[rachbendy]

Thanks Special-K, that helps a lot!!
Rachael