Max If Function across several Sheets

Hi All,

I recently came across a function which I cannot make it work.

As per attached file, I will need to retrieve the last contact date in master page after having my function checking all the weeks sheets in my file.

The function I am using is:

IFERROR(MAX(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,Week1:Week6!A$2:C$9)&"</b></a>","//b[preceding::*[1]="""&B2&"""]")),"Not Found")

However, it looks like that this works when there are no comments in the weeks sheets while it doesn't work when there are comments.

How can I adjust this function to make it work independently from the presence of comments?

Thank you