I'm struggling to create a formula that will not only look for a name match from one sheet to another, but it will only return a match if the date on the row was within the past 6 months.
For finding a name match between sheets, I've been utilizing the following formula:
=IF(CONTAINS(Contractor@row, {Change and Offboarding Master Range 1}), "Yes", "No")
However, I'm unsure how to include a date limitation within this formula or if I should use a different formula?
Please help.
Thank you,
Anthony