Results 1 to 3 of 3

Thread: 14 day assignment

  1. #1
    Acolyte chrisl614's Avatar
    Join Date
    Apr 2019
    Posts
    27
    Articles
    0
    Excel Version
    2016

    14 day assignment



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,108
    Articles
    0
    Excel Version
    365
    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.
    Attached Files Attached Files

  3. #3
    Acolyte chrisl614's Avatar
    Join Date
    Apr 2019
    Posts
    27
    Articles
    0
    Excel Version
    2016
    Worked perfectly! Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •