Case WHEN Submit Date > (Current Date -7) THEN WK1: Desired Result: WK1:1/11/2019 - 1/04/2019 WHEN Submit Date > (Current Date -7 AND Submit Date < (Current Date -14) THEN WK2: Desired Result: WK1:1/04/2019 - 12/28/2019 WHEN Submit Date > (Current Date -14 AND Submit Date < (Current Date -21) THEN WK3: Desired Result: WK1:12/28/2019 - 12/21/2019 WHEN Submit Date > (Current Date -21 AND Submit Date < (Current Date -28) THEN WK4: Desired Result: WK1:12/21/2019 - 12/14/2019 WHEN Submit Date > (Current Date -28 AND Submit Date < (Current Date -31) THEN WK5: Desired Result: WK1:12/14/2019 - 12/07/2019 ELSE Return This END