Merge 2 datasets by common id field AND 2 dates if they are within 365 days of each other

Hi,

I have 2 datasets that I would like to merge together. There is a common id field between the two but I need the two datasets to also align by date. There is no common date field. One dataset has a created date field and the second dataset has a completed date field. I would like to align the datasets by id and date if the 2 dates are within 365 days of each other. Is there a way to do this in Excel?

Thank you!