How can I incorporate 'IFERROR' in the below formula?
In certain circumstances there will be no date in both ' CAT - Date of Last Activity' & Date of Last Activity plus 7 years. Therefore I receive the error message #INVALID OPERATION. How do I add the 'IFERROR' function to the below formula to stop this from happening. I had a go but can't seen to figure it out. Thanks!
=IF(AND([CAT - Search Outcome]@row = "Found", [CAT - Date of Last Activity]@row <> "", [Date of Last Activity plus 7 years]@row < [email protected]), 1, 0)