14 day assignment

chrisl614

Member
Joined
Apr 6, 2019
Messages
30
Reaction score
0
Points
6
Excel Version(s)
2016
I have a master file with over 5k records to keep track of assignments. In this file new records keep getting added on a bi-weekly basis.
Each person that's listed in the file has a Unique ID, and a date that the assignment was assigned. You can only receive 1 assignment every 14 days. I need a conditional format or something to indicate if anyone received more than one assignment in a 2 week period at any point and moving forward.
Keep in mind each person might be on this list more than 10 times.

Thanks in advance.
 

Attachments

  • date 14days.xlsx
    8.1 KB · Views: 3
Test this one thoroughly (I haven't):
Code:
=SUMPRODUCT(((($B$2:$B$8<=($B2+14))+($B$2:$B$8>=($B2-14)))>1)*($A$2:$A$8=$A2))>1
Attached has this in column D for a visual TRUE/FALSE for development only, and has it in conditional formatting.
 

Attachments

  • ExcelGuru11361 date 14days.xlsx
    13.1 KB · Views: 6
Back
Top