If date falls within a date range in a list, then apply the end date of the date from the list
I have the following:
• Module with a column for Lease Ending Date - My particular date I'm using for this example is 7/14/19
• List built that houses bi-weekly ending dates the Lease Ending Date can fall into (Goes from 2/3/19 to 2/17/19 to 3/3/19, etc.) - The date range the Lease Ending Date falls into is 7/8/19 - 7/21/19. (Image of List attached)
In a new column, I want a formula that will look at the Lease Ending Date, determine which date range the Lease Ending Date falls into within the list and apply the end date, 7/21/19 in this case, as the result
Can someone please help me build out a formula for this?