Formula to locate an entry with a date up to 15 days in the future

[njones3]

Hi,

I am trying to work out a formula which will allow me locate a related entry with a future date (up to +15 days).

I have 2 separate lists, one of customers and their contract end dates and a one of customers with renewed contracts and their start dates.

I want to look up based on the customer, the old contract end date and pull back the renewal contract start date with a 15 day window.

Thanks in advance for your help,

 

[MPaul100]

No sure if I got it, but basically, you need a vlookup for end date based on contract and for renewal something like =date(year(vlookup to return the date),month(vlookup to return the date),day(vlookup to return the date)-15)