Hello,
I have two tables and not sure how to go about it. Below is a snapshot of my 1st table (data) but I am trying to find the Weeks Out.
The 2nd table has the Weeks Out. The Weeks Out Date is the week it starts so if the Date is within the week of the weeks out date then the corresponding weeks out is populated.
| Session | Date | Weeks Out |
| 202531 | 7/11/2024 | |
| 202435 | 7/10/2024 | |
| 202435 | 7/9/2024 | |
| 202511 | 7/8/2024 | |
| 202511 | 7/7/2024 | |
| 202511 | 7/6/2024 | |
| 202511 | 7/5/2024 | |
| 202511 | 7/4/2024 | |
| 202511 | 7/3/2024 | |
| 202511 | 7/2/2024 | |
| 202511 | 7/1/2024 | |
| 202511 | 6/30/2024 | |
| 202511 | 6/29/2024 | |
| 202511 | 6/28/2024 | |
| 202511 | 6/27/2024 | |
Here is my 2nd table:
| Session | Start Date2 | End Date2 | Model | Weeks Out | Weeks Out Date | Data Through |
| 202435 | 6/24/2024 | 8/18/2024 | last 3 5's | 0 | 6/24/2024 | 6/23/2024 |
| 202435 | 6/24/2024 | 8/18/2024 | last 3 5's | 1 | 6/17/2024 | 6/16/2024 |
| 202435 | 6/24/2024 | 8/18/2024 | last 3 5's | 2 | 6/10/2024 | 6/9/2024 |
| 202435 | 6/24/2024 | 8/18/2024 | last 3 5's | 3 | 6/3/2024 | 6/2/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 4 | 7/29/2024 | 7/28/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 5 | 7/22/2024 | 7/21/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 6 | 7/15/2024 | 7/14/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 7 | 7/8/2024 | 7/7/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 8 | 7/1/2024 | 6/30/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 9 | 6/24/2024 | 6/23/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 10 | 6/17/2024 | 6/16/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 11 | 6/10/2024 | 6/9/2024 |
| 202511 | 8/26/2024 | 10/20/2024 | last 3 1's | 12 | 6/3/2024 | 6/2/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 12 | 7/29/2024 | 7/28/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 13 | 7/22/2024 | 7/21/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 14 | 7/15/2024 | 7/14/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 15 | 7/8/2024 | 7/7/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 16 | 7/1/2024 | 6/30/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 17 | 6/24/2024 | 6/23/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 18 | 6/17/2024 | 6/16/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 19 | 6/10/2024 | 6/9/2024 |
| 202515 | 10/21/2024 | 12/15/2024 | last 3 5's | 20 | 6/3/2024 | 6/2/2024 |
| 202521 | 1/6/2025 | 3/2/2025 | last 3 1's | 23 | 7/29/2024 | 7/28/2024 |
| 202521 | 1/6/2025 | 3/2/2025 | last 3 1's | 24 | 7/22/2024 | 7/21/2024 |
